2.22 Write an SQL statement to display all of the columns using *.
SELECT *
FROM INVENTORY;

2.26 Write an SQL statement to display the SKU, SKU_Description, and Warehouse on products having QuantityOnHand equal to 0. Sort the results in descending order by Warehouse and ascending order of SKU.
SELECT SKU, SKU_Description, Warehouse
FROM INVENTORY
WHERE QuantityOnHand =0
ORDER BY Warehouse DESC, SKU;

2.30 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. Use the BETWEEN keyword.
SELECT SKU, SKU_Description, WarehouseID, QuantityOnHand
FROM INVENTORY
WHERE QuantityOnHand BETWEEN 2 AND 9;

2.30 (11th Edition) Write an SQL statement to display the SKU and SKU_Description of all items stored in the Seattle, Chicago, or New Jersey warehouse. Use the IN keyword.
SELECT SKU, SKU_Description
FROM INVENTORY
WHERE Warehouse IN ('Seattle', 'Chicago', 'New Jersey');

2.35 Explain the difference between the SQL built-in functions COUNT and SUM.
COUNT counts the number of rows or records in a table, while SUM adds up the data values in the specified column.
2.35 (11th Edition) Write an SQL statement to show SKU and SKU_Description for all products having an SKU_Description starting with “Half-dome”.
SELECT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description LIKE 'Half-dome%';

2.36 Write an SQL statement to show SKU and SKU_Description for all products having Description that includes the word “Foot”.
SELECT SKU, SKU_Description
FROM INVENTORY
WHERE SKU_Description LIKE '%Foot%';

2.38 Write an SQL statement that uses all of the built-in functions on the QuantityOnHand column. Include meaningful column names in the result.
SELECT COUNT (QuantityOnHand) AS Number_Of_Records, SUM (QuantityOnHand)