Due: Wednesday, October 20

Please upload your solutions to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

(48pt) Complete the following queries using the sample database University (university-create.sql, university-drop.sql). Feel free to insert more records into the tables to test your queries, but do not use any views.

• Exercise 4.20 (a), (c), (e), (g), (i), (k), (m), (o), (q)
• Exercise 4.21 (a), (c), (e)

Please put all the queries in an SQL script hw2-queries.sql, and make sure that each query is labeled with the exercise number, e.g.