2.20 Write an SQL statement to display unique WarehouseIDs.
SELECT DISTINCT WarehouseID
FROM INVENTORY;

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.

SELECT SKU, SKU_Description, WarehouseID,
QuantityOnHand
FROM INVENTORY
WHERE
QuantityOnHand > 1
AND
QuantityOnhand < 10;

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’.

SELECT DISTINCT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description
LIKE
'Half-dome%';

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.

SELECT DISTINCT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description
LIKE
'__d%';

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 of TotalItemsOnHand.

SELECT WarehouseID, SUM(QuantityOnHand) AS
TotalItemsOnHand
FROM INVENTORY
GROUP BY WarehouseID
ORDER BY SUM (QuantityOnHand) DESC;

2.42 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, Ware- houseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or
Chicago warehouse. Do not use the NOT IN keyword.

SELECT
SKU, SKU_Description, INVENTORY.WarehouseID
FROM
INVENTORY, WAREHOUSE
WHERE
INVENTORY.WarehouseID=WAREHOUSE.WarehouseID
AND
WarehouseCity Except ('Atlanta','Bangor','Chicago');

2.44 Write an SQL statement to produce a single column called ItemLocation that com- bines the SKU_Description, the phrase “is in a warehouse in”, and WarehouseCity. Do not be