Write answers for each question with these two form:

QUERY BY EXAMPLE and RELATION ALGEBRA

1: List the Order# and Ship_date for all orders shipped from Warehouse# W2.

2: List the WAREHOUSE information from which the CUSTOMER named Jose Lopez was supplied his orders. Produce a listing: Order#, Warehouse#.

3: 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.

4: List the orders that were not shipped within 30 days of ordering.

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