Question 2 Tables below are extracted from a manufacturing company database Table 7: WAREHOUSE STRUCTURE Column Name Type Key WarehouseID Integer Primary Key Required Remarla YES YES Warehouse City VARCHAR2(30) WarehouseState VARCHAR2(2) YES Table 5: WAREHOUSE Warehouse In Warehouse WarehouseStats Manager SaFeet 100 Atlanta GA Dave Jones 125.000 200 Chicago IL Lucille Smith 100,000 300 Bangor MA Bart Evans 150,000 400 Seattle WA Dale Rogers 130.000 IN (GA TL "MA', 'WA') only Manager VARCHAR2(35) SqEest Integer Table 6: INVENTORY WarehouseID SKU [8 marks] 100100 100 200 100100 100100 300 400 100100 100200 SKU Description Quantity Quantitron Hand Order Std. Scuba Tank, Yellow 250 0 Std. Scuba Tank, Yellow 100 50 Std. Scuba Tank, Yellow 100 0 Std. Scuba Tank, Yellow 200 0 Std. Scuba Tank, Magenta 200 30 Std. Scuba Tank, Magenta 75 75 Std. Scuba Tank, Magenta 100 100 Std. Scuba Tank, Magenta 250 0 100 200 300 400 100200 100200 100200 Write an SQL statement to show the WarehousID and average QuantityOnHand of all items stored in a warehouse managed by 'Lucille Smith'. Use a subquery. [8 marks) (6) Write an SQL statement to show a unique SKU and SKU. Description for all products having a 'd' in the third position from the left in SKUL.Descrintion, [4 marks] (c) Write an SQL statement to create table WAREHOUSE. The structure of the table is given in Table 7 below