USE FOLLOWING TABLES TO ANSWER FOLLOWING QUESTIONS

WAREHOUSE $($WarehouseID$,$ WarehouseCity, WarehouseState, Manager, SquareFeet$)$

INVENTORY $($WarehouseID$,$ SKU, SKU$\_$Description, QuantityOnHand, QuantityOnOrder$)$

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 using JOIN ON syntax.