Lab 5. Aggregations
CS122, Fall 2011


(30pt) Complete the following queries in SQL. Please put your queries in an SQL script file lab5.sql. and upload it to CSNS at the end of the lab. Note that file uploading will be disabled automatically after 4:00pm, and late submission will not be accepted.

  1. Chapter 3, p.65, Exercise 1-5, 7, 8.
  2. Chapter 4, p.93, Exercise 3, 7, 8.
  3. Chapter 5, p.139, Exercise 5.
Note that the total of this assignment is 30pt. You will receive 3pt extra credit if you complete all 11 queries.