Jose P. Mendoza
CISS 430 Database Systems
January 24, 2016
Instructor: Gary Farrar
Assignment: Week 2 Dropbox

Q 2.20 Write an SQL statement to display unique WarehouseIDs.
Statement: select DISTINCT WarehouseID from INVENTORY Q 2.29 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Do not use the BETWEEN keyword.
Statement: select SKU, SKU_Description, WarehouseID, QuantityOnHand from INVENTORY where QuantityOnHand > 1 and QuantityOnHand < 10;

Q 2.31 Write an SQL statement to show a unique SKU and SKU_Description for all products having an SKU description starting with “Half-Dome”.
Statement: select SKU, SKU_Description from INVENTORY where SKU_Description = 'Half-dome';

Q 2.33 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.
Statement: select SKU, SKU_Description from INVENTORY where SKU_Description like '__d%';

Q 2.36 Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order to TotalItemsOnHand.
Statement: select distinct WarehouseID, SUM(QuantityOnHand) as TotalItemsOnHand from INVENTORY group by WarehouseID order by TotalItemsOnHand;

Q2.42 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState for all items stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the NOT IN keyword.
Statement: SELECT SKU, SKU_Description, WAREHOUSE.WarehouseID, WarehouseCity, WarehouseState FROM INVENTORY, WAREHOUSE WHERE INVENTORY.WarehouseID=WAREHOUSE.WarehouseID AND WarehouseCity <> 'Atlanta' AND WarehouseCity <>