Question: Submit the sql file only. Use comments to label the queries with the number of the exercise. Include USE statements or fully qualified names to
Submit the sql file only. Use comments to label the queries with the number of the exercise. Include USE statements or fully qualified names to guarantee the correct database is being accessed. The file should be able to be opened with MySQL Workbench and executed as a single script without errors. Use the cape_codd database for questions 1-5. 1. Write a SQL statement to display the Warehouse D. SKU, and QuantityOnHand columns of the inventory table with SKU equal to 201000 and QuantityOnHand greater than 0. 2. Write a SQL statement to display the WarehouseID, SKU, and QuantityOnHand columns of the inventory table with SKU equal to 100100 or 100200 3. Write a SQL statement to display all columns from the warehouse table with Warehousels equal to 100 or 500. 4. Write a SQL query that displays all columns from the inventory table with QuantityOnHand between 300 and 500, endpoints included. Order by QuantityOnHand. Use BETWEEN 5. Write a SQL query that displays all columns from the inventory table with QuantityOnHand between 300 and 500. endpoints included. Order by QuantityOnHand. Don't use BETWEEN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
