Subject: SQL Query Formulation Definition You are given a sample MS Access University database (University.accdb) with tables populated with sample data. The database file can be downloaded from our Blackboard course shell. Do the followings to complete this assignment: Formulate the below queries in SQL View in MS Access,

Just write the query code.

4. Formulate a SQL query in SQL View to find the total amount of salary paid to the Associate Professors?

5. Formulate a SQL query in SQL View to list the students whose names start with C and who are from Seattle.