Additional SQL Problems

     
Relation Schema

Suppliers(SNum, SName, SCity, Status) 
Parts(PNum, PName, Color, Weight, PCity) 
Supplies(SNum, PNum, Quantity) 

SNum and PNum are foreign keys in Supplies.

Questions:
                                             
     1.   Show all supplier names that supplies green parts or red parts.

     2.   Show all supplier names with their status doubled.

     3.   Show the number of suppliers and their average status.

     4.   Show all supplier names with status larger than the average status.

     5.   Show all supplier names with status greater than status of S1, S3 and S6

     6.   Show all supplies in ascending PNum and descending quantity.

     7.   Show the names and status of the suppliers with the highest status.

     8.   Show all part inventory on those part with total quantity of 200 or above.

     9.   Show all suppliers with names containing the string "Toy".

     10.  Show all suppliers with names starting with 'A_'

     11.  List all part inventory.

     12.  Show all supplier names that supply all parts.

     13.  Show all SNum that supplies all parts supplied by S1.