Use information in screenshot below. MySQL DBMS. 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.

os 0274|2 2 5 6 4 8 1 2 5 3 3 2 1 5 1212848 G000000 27 7429 4123456 244444 3 3 T00000 ET N-13333333534662255613456 NBSSCC 123 456 123-4567 11222|22 2 2 2 3 3 4 4 5 5 5 5 5 5 5 5 5 5 J