This preview shows page 1. Sign up to view the full content.
Unformatted text preview: , pname, color); Catalog (sid, pid , cost). Write the following queries in SQL : 1. Find the snames of suppliers that supply only parts that cost less than $200. (10 points) 2. Find the pids of parts that are supplied by every supplier who lives in Ithaca and that are supplied by every supplier who lives in Cortland (10 points) 3. For every supplier that only supplies green parts, print the name of the supplier and the total number of parts that she supplies. (10 points) Question 4 (20 points). Exercise 14.4 in the book, sub-questions 2-5 (5 points each)...
View Full Document
This note was uploaded on 01/10/2010 for the course CS 4320 taught by Professor Koch during the Fall '07 term at Cornell University (Engineering School).
- Fall '07