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
- Fall '07
- Following, Central processing unit, CPU cache, OBD-II PIDs