1- Create view for all customers with their orders

2- Create a query to display the orders that were not shipped within 30 days of ordering

3- Delete all orders for customer named "Sara".

4- List all customer names whose orders were shipped from a warehouse in the same city as they live in.

USE ORACLE SQL THANK YOU!

Customer custNo 11 22 33 cname Sara Fatma Omar Ali City Doha Doha Khor Shimal Khor 44 55 Hassan Odate Orders Order No 21 22 03-04-02 09-03-04 CustNo Ord_amt 11 10000 22 11000 33 14000 44 16000 55 20000 23 23-01-01 11-08-08 24 25 06-10-10 Item ItemNo Unit Price 1 1100 2 1200 3 1300 4 1400 5 1500 Qty 20 order_Item Order No 21 25 22 24 23 un 30 Item No 1 5 2 4 3 40 10 60 shipment Order No WarehouseNo Ship_date 21 W1 11-Jan-02 25 W2 24-Feb-10 22 W3 13-Jun-05 24 W4 16-Sep-09 23 W5 28-Apr-03 Warehouse WarehouseNo City W1 Najma W2 Khor W3 Doha W4 Muntza W5 Rayaan