Question: a,b,c,d Use both INVENTORY and WAREHOUSE tables to write SOL statements for the following queries. Make sure to include the screen capture of the SQL
a,b,c,d

Use both INVENTORY and WAREHOUSE tables to write SOL statements for the following queries. Make sure to include the screen capture of the SQL output that you get after executing each of the query. (5 points each) 3. a) Display the SKU, SKU_Description, WarehouselD for all items stored in a warehouse managed by Lucille Smith. Use a subquery. b) Display the SKU, SKU_Description, and WarehouselD for all items stored in a warehouse managed by 'Lucille Smith'. Use a join, but do not use JOIN ON syntax. Display the SKU, SKU_Description, WarehouselD for all items stored in a warehouse managed by 'Lucille Smith'. Use a join using JOIN ON syntax. c) d) Display the WarehouselD, WarehouseCity, WarehouseState, Manager, SKU, SKU_Description, and QuantityOnHand of all items with a Manager of Lucille Smith'. Use a join using JOIN ON syntax
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
