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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!