Question: 3. Use both INVENTORY and WAREHOUSE tables to write SQL statements for the following queries. Make sure to include the screen capture of the SQL

3. Use both INVENTORY and WAREHOUSE tables to write SQL 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) a) Display the SKU, SKU_Description, WarehouseCity as ItemCity, WarehouseState as ItemState for all items. Use JOIN ON syntax. b) Display the SKU, SKU Description, WarehouseCity as ItemCity, WarehouseState as ItemState for all items. Use INNER JOIN ON syntax. c) Display the SKU, SKU_Description, WarehouseCity as ItemCity, WarehouseState as ItemState for all items. Include all rows from the WAREHOUSE table. Use LEFT OUTER JOIN or RIGHT OUTER JOIN syntax
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
