please solve 2-3-10-11

use sql please

1. Create the following tables Customer Field name custo came city gender phone Item Datatype Number Varchar2 Varchar2 Char Varchar2 size Note 3.PK 25 Unique 12 1 Mor 6 Field name Data Type Se Note Item No Number 3 PK UnitPrice Number 6,2 Orders Field name Data Type Sue Note 1 CPSS 151-2 3 PK NN FK Customer 5 size Note 3 PK 3 F Item 5 Order No Number Odate Date CustNo Number Ord_art Number Order_item Field name Datatype Ordero Number Item No Number Number Shipment Field name Datatype Order No Number WarehouseNo Varchar2 Ship date Date Warehouse Field name Data type Warehouse No Varcharz City Varchar2 size Note 3 PK FK-Warehouse size Note 3 PK 12 2. Create sequence for customer number start with 11 maximum value 999 and increment by 11, use this sequence when insert values to the customer table. 3. Create sequence for order number start with 21, end with 99. use this sequence when insert values to the orders table. 4. Create sequence for item number, use this sequence when insert values to the item table 5. Fill the table by following date Customer custo 11 22 33 chame SARA FATMA OMAR City DOHA DOHA KHOR gender phone F 111111 F M 333333 313 M M 444444 555555 Ord amt 100 110 140 160 200 44 ALI SHIMAL 55 HASSAN KHOR Orders Order No Odate CustNo 21 3/4/2002 11 22 9/3/2004 22 23 23/01/2001 33 24 11/8/2008 44 25 6/10/2010 55 Item Item No Unit Price 1 1100 2 1200 3 1300 4 1400 5 1500 order_item Order No Item No Qty 1 200 5 200 2 250 24 4 300 23 3 600 shipment Order No WarehouseNo Ship date 21 W1 1/11/2002 25 W2 24/12/2010 22 W3 13/5/2005 24 W4 16/9/2008 23 WS 28/4/2001 Warehouse Warehouse No City WI NAJMA W2 KHOR W3 DOHA 3 CMIP5352 Sping 351 - HW2 CENCE Nm W4 ws MUNTZA RAYAAN 6. Create view customers_vw for all customers with their orders. 7. Create a view warehouse_vw for the warehouse information from which the customer named "FATMA was supplied her orders. Produce a listing: orderno, WarehouseNo. 8. Create a view summary_vw for 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 query to display the orderNo and Ship_date for all orders shipped from warehouseNo W2. 10.Create a query to display the orders that were not shipped within 365 days of ordering 11. Create a query to display the orderNo for orders that were shipped from all warehouse that is in RAYAAN. 12. Find the item with the maximum unit price. 13.List all customer names whose orders were shipped from a warehouse in the same city as they live in. 14.Delete all orders for customer named SARA. 15.Delete all items from order_item that have a price greater than the average price. 16. All customers who lived in DOHA, are moved to MAUITHER. 17.Increase price for all item by 25%