Table 5: WAREHOUSE WarehouseID WarehouseCity WarehouseState Manager 100 Atlanta GA Dave Jones 200 Chicago IL Lucille Smith Bangor Bart Evans 400 Seattle WA Dale Rogers SqFeet 125,000 100,000 150,000 130,000 300 Table 6: INVENTORY WarehouseID SKU SKU_Description Order 100 100100 QuantityOn QuantityOn Hand 250 0 100 50 200 300 100 0 400 200 0 Std. Scuba Tank, Yellow Std. Scuba Tank, Yellow Std. Scuba Tank, Yellow Std. Scuba Tank, Yellow Std. Scuba Tank, Magenta Std. Scuba Tank, Magenta Std. Scuba Tank, Magenta Std. Scuba Tank, Magenta 100100 100100 100100 100200 100200 100200 100200 100 200 200 75 30 75 100 300 100 400 250 0 (a) Write an SQL statement to show the WarehouseID and average QuantityOnHand of all items stored in a warehouse managed by "Lucille Smith'. Use a subquery. [8 marks] 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 SKU_Description. (4 marks] (c) Write an SOL statement to create table WAREHOUSE. The structure of the table is given in Table 7 below. Page 5 of 9 CISB 214/C/SB3213, Sendster I, 2020/2021 Remarks Table 7: WAREHOUSE_STRUCTURE Column Name Type Key WarehouseID Integer Primary Key WarehouseCity VARCHAR2(30) Warehouse State VARCHAR2(2) Required YES YES YES IN ("GA", MA', 'WA) only VARCHAR2(35) Manager SqFeet Integer