数据库多表查询

供货商表suppliers: (sid,sName,address)
零件表    parts:   (pid,pName,color)
价目表   catalog:  (sid,pid,price)
  其中各个供货商可能提供多个重复的产品
建立表 且 --写出下列SL语句：
1.找出供应红色零件的供应商的名字：
2.找出供应红色或黑色零件的供应商ID：
3.找出供应红色零件或 地址在‘Rome:XXX Apart:AAA SSS Road’的供应商ID：
4.找出供应红色和黑色零件的供应商ID：
5: 找到供应所有商品的供货商的ID:
6.找出提供同一种零件的供应商ID，其中第一个供应商的供应价格比第一个供应商的价格贵
7.找出至少有2个不同供应商供货的零件ID
8.找出由SONY供应的最贵的零件
9.找出任何供应商供应价格都少于200的零件ID
*/
suppliers values
('s0001','IBM','Rome:XXX Apart:AAA SSS Road')
('s0002','Intel','Rome:sss Apart:www yree Road')
('s0003','HP','Rome:eee Apart:TTT OOO Road')
('s0004','SONY','Rome:ccc Apart:uuu SiS Road')
('s0005','Lenovo','Rome:lll Apart:lll lala Road')parts values
('p0001','DDR-RAM','BLACK')
('p0002','SD-RAM','BLACK')
('p0003','Monitor','White')
('p0004','Monitor','Silver')
('p0005','keyboard','white')
('p0006','keyboard','black')
('p0007','mouse','red')
('p0008','webCamera','red')
catalog values
('s0001','p0002',300)
('s0002','p0005',100)
('s0003','p0001',300)
('s0003','p0002',270)
('s0003','p0003',1000)
('s0003','p0004',1200)
('s0003','p0005',100)
('s0003','p0006',100)
('s0004','p0002',300)
('s0004','p0003',1500)
('s0004','p0004',1500)
('s0004','p0005',55)
('s0005','p0007',20)
('s0003','p0008',30)