$13-(20$ points$)$ Consider the following six relations for an order$-$processing database application:

CUSTOMER$($Cust#$,$ Name, City$)$

ORDER$($Order#$,$ Date, Cust#$,$ Ord$\_$amt$)$

ORDER$\_$ITEM$($Order#$,$ Item#$,$ Qty$)$

ITEM$($Item#$,$ Unit$\_$price$)$

SHIPMENT$($Order#$,$ Warehouse#t$,$ Ship$\_$date$)$

WAREHOUSE$($Warehouse#$,$ City$)$

Specify the following queries in SQL:

a$.$ List the Order# and Ship$\_$date for all orders shipped from Warehouse# W$2.$

b$.$ List the WAREHOUSE information from which the CUSTOMER named Jose Lopez was supplied his

orders. Produce a listing: Order#$,$ Warehouse#$.$

c$.$ Produce a listing Cname, No of$\_$orders, Avg$\_$order$\_$amt, where the middle column is the total number of

orders by the customer and the last column is the average order amount for that customer and the customer

has had at least $5$ orders.

d$.$ List the Order# for orders that were shipped from all warehouses that the company has in New York.