--CS 630 hw 2 Solutions: Problem 4.3 of R&G
--Jinghui Zhou  (student name)
--start up script on topcat or pe07
--connect to dbs3 using sqlplus
--use "set echo on", then run this by "@problem4.sql" 
--exit from sqlplus, then exit again to finish typescript
--"mv typescript problem4.txt" to rename it for delivery
-- Note: all-caps for SQL keywords is not needed
-- But we need to capitalize color names in table parts to match data
--[4.3 part1] Find the names of suppliers who supply some red part.
SELECT DISTINCT s.sname
FROM suppliers s, parts p, catalog c
WHERE p.color='Red' AND c.pid=p.pid AND c.sid=s.sid;
