Question: 1. Write an SQL statement to display the SKU, Description, and Warehouse on products having QuantityOnHand equal to 0 . Order the results in ascending


1. Write an SQL statement to display the SKU, Description, and Warehouse on products having QuantityOnHand equal to 0 . Order the results in ascending order by Warehouse. 2. Write an SQL statement to display the SKU, Description, and Warehouse on products having QuantityOnHand equal to 0 . Order the results in descending order by Warehouse. 3. Write an SQL statement to display the SKU, Description, and Warehouse on products having QuantityOnHand equal to 0 . Order the results in descending order by Warehouse and Ascending order of SKU. 4. Write an SQL statement to display the top 3 rows for all products that have a QuantityOnOrder equal to 0 . 5. Write a SQL statement to display SKU and Description for all products that have a QuantityOnHand greater than 0 . Order by QuantityOnHand descending and SKU ascending. 6. Write a SQL statement to show all the data with the warehouse name of "Chicago" 7. Write a SQL statement to show all the data for products that contain the description "Locking carabiner". Order the QuanityOnHand in Ascending Order. 8. Write an SQL statement to show SKU and Description for all products having a Description starting with "Half-dome". 9. Write an SQL statement to show SKU and Description for all products having Description that includes the work "Foot". 10. Select the Top 5 rows from the Inventory table that contain the word "Tank" in the description. 11. Write a SQL statement to show SKU, Warehouse, and Description where description can start with the letter 1HH or nS and end with any characters. 12. Write a SQL statement to show all data where manager in the warehouse table starts with the letters E,J,R and ends with the letter S. 13. Select the Top 3 Rows from Inventory where QuantityOnHand is greater than 100 . 14. Write a SQL Statement that shows all products that have a QuantityOnOrder not equal to 0 with QuantityOnHand in Ascending Order. 15. Write a SQL statement to show all SKU_Data where department contains the word "water" and the buyer starts with "Pete
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
