Lab 6. Subqueries and Set Operations
CS122, Summer 2008


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

  1. Chapter 6, p.161, Exercise 1-5, 7.
  2. Complete the following queries without using joins:

[NOTES]