Ok... Given:
Suppliers(SN, sname, status, city)
Parts(PN, pname, color, weight, city)
Projects(JN, jname, city)
Shipments(SN, PN, JN, qty)
(Keys are in Caps)
Quesitons:
Get Supplier numbers for suppliers supplying some project with part 'p2' in a quantity greater than the average shipment...