DATABASE SQL 6. Create a view based on a query to display the order No and Ship_date for all ordersshipped from warehouseNo WH2.7. Create a view based on a query to display the warehouse information from which thecustomer named "Fatma" was supplied her orders. Produce a listing: orderNo,WarehouseNo,8. Create a view based on a query to display the cname,No_of_orders, Avg_order_amt,where the middle column is the total number of orders and last column is the averageorder amount for that customer.9. Create a view based on a query to display the orders that were not shipped within 30days from the order date.

5. Create a view based on a query to display the orderNo and Ship_date for all orders shipped from warehouse No WH2. 7. Create a view based on a query to display the warehouse information from which the customer named "Fatma" was supplied her orders. Produce a listing: orderNo, WarehouseNo, 3. Create a view based on a query to display the cname,No_of_orders, Avg_order_amt, where the middle column is the total number of orders and last column is the average order amount for that customer. 9. Create a view based on a query to display the orders that were not shipped within 30 days from the order date.