Using SQL

1. Cite the following lobes 2 the ble bride CUTE! Gust este CATE Sana Oly Data ca Number 22 22 un | Vandu Merchand 6 ty nap Her Ha Number 3 nike Orders Order Ode 21 0302 09-03-01 23 00 01 24 Il es 010 Cara Ord an 11 BE 22 35 ILLE LE 55 BELE 130 1 2 4 S 1400 Pictor Note arde het Ordrhe I Uty humbur 3 PK Oreo Us shipment Order No Warehouse No Ship date 21 W1 11-Jan-02 25 W2 24-Feb-10 22 W3 13-Jun-05 24 W4 16-Sep-09 23 WS 28-Apr-03 Warehouse WarehouseNo City W1 Najma W2 Khor W3 Doha W4 Muntza WS Rayaan 3. Create sequence for customer number start with 1 and end with 999. 4. Create view for all customers with their orders. 5. Create a query to display the orderNo and Ship_date for all orders shipped from warehouseNo W2. 6. Create a query to display the warehouse information from which the customer named "Fatma" was supplied her orders. Produce a listing: orderNo, WarehouseNo, 7. Create 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. 8. Create a query to display the orders that were not shipped within 30 days of ordering. 9. Create a query to display the orderNo for orders that were shipped from all warehouse that the company has in Rayaan. 10. Delete all orders for customer named "Sara". 11. List all items that have a price greater than the average price. 12. Find the item with the maximum unit price. 13. List all customer names whose arders were shipped from a warehouse in the same city as they live in 4 CMP5351-5ping 351 - HW del Cute Nuw 3 15 13 4 13 20 OD 10 Or 15 Orerem 3 we W 3 * Ure TH Number Numbe a IS up Shpre ahmat Ware 21 WI X W2 ws fen No Urla Number 3 MARL 24 Waruhuset Vardar 2 -Ware De Youse Yara WI W2 WA Warehouse Note Wars Varcara 3 PK Wrtai ?? WS 3. Creare seguente for susterbar start in landed 222 1 ttaiarmaththai aL Category to day the order_colores pped from 6. Questo che si ochichte der