Lab 4. Functions
CS122, Summer 2007

(24pt) Complete the following queries in SQL. Please put your queries in an SQL script file lab4.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 5, p.138-139, Exercise 1-4, 6-10.
  2. Find the names of the studio contacts whose email domains do not match their studio's web domains. For example, the email domain of Gardner Roberts is, which matches the studio's web domain, but Manuel Austin's email domain does not match the studio's web domain

Note that