1. Print supplier numbers for suppliers who are located in the same city as supplier S1. Do not include S1 in the answer.
2. Print supplier numbers for suppliers who ship at least all those parts shipped by supplier S3. Do not include S3 in the answer(And do not use COUNT()).
3. Print supplier numbers for suppliers who ship at least one type of red part.
4. Print supplier numbers for suppliers who do not ship any red parts.
5. Print supplier numbers for suppliers who ship ONLY red parts.
6. Print supplier names for suppliers who do not currently ship any parts.
7. Print supplier names for suppliers who ship at least one part that is also shipped by supplier S2. Do not include S2 in the answer.
8. Print supplier numbers for suppliers with status value less than the current average status value of all suppliers.
9. Print all the shipment information for the shipment(s) with the highest unit cost (i.e. price).
10. Print all the shipment information for the shipment(s) with the highest total cost, (i.e. price*Qty).
11. Print all the supplier information for the supplier(s)making the most money. The supplier money is determined by the sum of all shipment cost. Each shipment cost is found by the number of units being shipped times the price per unit.
12. For each supplier (including the one who doesn’t ship any parts), print the supplier number and how many different parts shipped. For example, S1 6; S2 2, ...
13. For each supplier (including the one who doesn’t ship any parts), print the supplier number, supplier name, total cost of all shipments, and how many different parts shipped.
14.   

supplier Sno Sname Status s1 Smith 20 20 City London 33 s2 Jones 10 Paris $3 Black 30 Paris s4 Clack 20 London $5 95 Adams 30 NULL part Pno Pname Color Weight City p1 Nut Red 12 London p2 Bolt Green 17 Paris p3 Screw NULL 17 Rome 160 p4 Screw Red 14 London p5 Cam Blue 12 Paris p6 8 Cong Red 19 London