2.44 Write an SQL statement to produce a single column called ItemLocation that combines the SKU_Description, the phrase is located in. and WarehouseCity. Do not be concerned with removing leading or trailing blanks.

2.45 Write and SQL statement to show the SKU, SKU_Description, and WarehouseID for all items stored in a warehouse managed by Lucille Smith. Use a subquery.

2.52 Write a SQL statement to display the WarehouseID, the sum of QuantityOnOrder, and the sum of QuantityOnHand, grouped by WarehouseID and QuantityOnOrder. Name the sum of QuantityOnOrder and the sum of QuantityOnHand as TotalItemsOnHand. Use only the INVENTORY table in your SQL statement.

2.55 Write an SQL statement to join WAREHOUSE and INVENTORY and include all rows of WAREHOUSE in your answer, regardless of whether they have any INVENTORY. Include all columns of both tables, but do not repeat the join column.

WarehouseCity Warehouse State Manager Square Feet WarehouselD 100 Atlanta GA Dave Jones 125,000 200 Chicago Lucille Smith 100,000 300 Bangor ME Bart Evans 150,000 400 Seattle WA Dale Rogers 130,000 500 San Francisco Grace Jefferson 200,000 Figure 2-38 - Cape Codd Database WAREHOUSE Table Data WarehouseID 100 200 300 SKU 100100 100100 100100 100100 100200 100200 400 100 QuantityOnHand 250 100 100 200 200 75 100 250 0 0 300 QuantityOnOrder 0 50 0 0 30 75 100 O 5 00 500 200 300 100200 400 100 100200 101100 101100 200 300 101100 200 400 450 0 100 101100 101200 101200 101200 200 300 400 S KU Description 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 Dive Mask, Small Clear Dive Mask, Small Clear Dive Mask, Small Clear Dive Mask, Small Clear Dive Mask, Med Clear Dive Mask, Med Clear Dive Mask, Med Clear Dive Mask, Med Clear Half-Dome Tent Half-Dome Tent Half-Dome Tent Half-Dome Tent Half-Dome Tent Vestibule Half-Dome Tent Vestibule Half-Dome Tent Vestibule Half-Dome Tent vestibule Light Fly Climbing Harness Light Fly Climbing Harness Light Fly Climbing Hamness Light Fly Climbing Harness Locking Carabiner, Oval Locking Carabiner, Oval Locking Carabiner, Oval Locking Carabiner, Oval 500 500 0 250 100 50 101200 100 50 475 250 2 10 250 100 201000 200 2 300 201000 201000 201000 0 400 250 202000 100 200 250 250 202000 300 202000 0 400 1 100 0 300 250 0 202000 301000 301000 301000 100 200 250 250 250 200 300 400 250 100 301000 302000 302000 302000 0 200 300 400 1000 1250 500 0 500 1000 302000 Figure 2-39 - Cape Codd Database INVENTORY Table Data