for warehouses having fewer than two SKUs in their TotalltemsOnHandLT$3.$ Display the results in descending order of

TotalltemsOnHandLT$3.$

$2\mathrm{.}39$ In your answer to Review Question $2\mathrm{.}38,$ was the WHERE clause or the HAVING clause applied first? Why?

Use both the INVENTORY and WAREHOUSE tables to answer Review Questions $2\mathrm{.}40$ through $2\mathrm{.}52$:

$2\mathrm{.}40$ Write an SQL statement to display the SKU, SKU$\_$Description, WarehouselD, WarehouseCity, and WarehouseState for all items

stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the IN keyword.

$2\mathrm{.}41$ 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. Use the IN keyword.

$2\mathrm{.}42$ Write an SQL statement to display the SKU, SKU$\_$Description, WarehouseID, WarehouseCity, and WarehouseState of all items

not stored in the Atlanta, Bangor, or Chicago warehouse. Do not use the NOT IN keyword.

$2\mathrm{.}43$ Write an SQL statement to display the SKU, SKU$\_$Description, WarehouseID, WarehouseCity, and WarehouseState of all items

not stored in the Atlanta, Bangor, or Chicago warehouse. Use the NOT IN keyword.

$2\mathrm{.}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\mathrm{.}45$ Write an SQL statement to show the SKU, SKU$\_$Description, and WarehouselD for all items stored in a warehouse managed by

'Lucille Smith'. Use a subquery.

$2\mathrm{.}46$ Write an SQL statement to show the SKU, SKU$\_$Description, and WarehouseID for all items stored in a warehouse managed by

'Lucille Smith'. Use a join, but do not use JOIN ON syntax.