Use ONLY the INVENTORY table to answer these questions: 2.17 Write an SQL statement to display SKU and SKU_Description. Write an SQL statement to display SKU_Description and SKU. Write an

SQL statement to display WarehouselD. Write an SQL statement to display unique WarehouselDs. Write an SQL statement to display all of the columns without using the SQL asterisk (*) wildcard character. 2.18 2.19 2.20 2.21 2.22 2.23 2.24 2.25 2.26 Assignment #2 Questions 2.17 through 2.27 2.27 Write an SQL statement to display all of the columns using the SQL asterisk (*) wildcard character. Write an SQL statement to display all data on products having a QuantityOnHand greater than 0. Write an SQL statement to display the SKU and SKU_Description for products having QuantityOnHand equal to 0. Write an SQL statement to display the SKU, SKU_Description, and WarehouselD for products having ntity Hand equal to 0. Sort the results in ascending order by WarehouselD. Write an SQL statement to display the SKU, SKU_Description, and WarehouseID for products having QuantityOnHand greater than 0. Sort the results in descending order by WarehouseID and ascending order by SKU. Write an SQL statement to display SKU, SKU_Description, and WarehouseID for all products that have a QuantityOnHand equal to 0 and a QuantityOnOrder greater than 0. Sort the results in descending order by WarehouseID and in ascending order by SKU./n CS 3410 Assignment #2: SQL Statements 1. Go to the course website and download the following MS SQL Query files: New MSSQL-Cape-Codd-Create-Tables.sql New MSSQL-Cape-Codd-Insert-Data.sql 2. In SQL Server Management Studio, create a new database called Cape_Codd 3. From MS SQL Server Management Studio, click File ➜ Open → File and select the Create-Tables file you downloaded. 4. Execute the Create Table script ONLY ONCE. If you try to re-execute, you get error message. Verify that the tables are created. Make sure you refresh the object explorer view. You should see five tables being created. 5. Repeat steps 3, 4, and 5 for the second file (Insert-Data) to populate the tables. Again, execute the script ONLY ONCE. If you try to re-execute, you get error messages. Verify that the tables are populated using "Select Top 1000 Rows". Now, using table INVENTORY, work Review Questions 2.17 to 2.27. Write all statement in the same script and save into a text file called Ch2-Assignment2.sql. Add a comment block to the top of your script as follows: /******** /* Name: /* Class: /* Term: /* Assgn #: 2 CS3410 Spring 2021 / */ */ * * ****/ For each answer, add a comment line right before it with the question number such as: /* 2.23 */