For MySQL DBS

For each of the following English descriptions, provide a valid SQL statement and show the evaluated result (command line or screen capture). Views are not allowed and the SQL should be a single statement.

(a) Get project numbers and names for projects supplied by supplier S2.

(b) Get the full details for parts supplied by a supplier in London.

(c) Get all shipments where the quantity is in the range 300 to 750 inclusive.

(d) Get part numbers for parts supplied by a supplier in London to a project in London.

(e) Get all supplier-number/part-number/project number triples such that the indicated supplier, part and project are collocated.

(f) Get the triples in (e) that are not collocated.

(g) For each part being supplied to a project, get the part number, project number and the total quantity.

(h) Get part numbers for those parts supplied to all projects in London.

Show screenshot(s) of completion