For the following database schema:

Supplier: S $($s#$,$ sname, city$)$

Part: P $($p#$,$ pname, colour$),$

SuppliedBy: SP $($p#$,$ s#$,$ Quantity$)$

Write down the following in SQL:

a$)$ Get part numbers for all parts supplied and eliminate duplicates from the result.

b$)$ Get supplier number and name for suppliers in Cairo in descending order of supplier number.

c$)$ Get the part number and the total shipment quantity for each part

d$)$ Get the total number of suppliers

e$)$ Get supplier name for suppliers who supply part P$2($use nested Query$).$

f$)$ Get all parts whose names begin with the letter C$.$

g$)$ Add part P$7$ on table P$.$ The name and color at present are unknown

h$)$ Change the color of part P$2$ to yellow.

i$)$ Delete supplier S$1.$