Database Management Systems SQL - Structured Query Language - Single table queries Using the following table, create the SQL commands below that will produce the required results. 1. List the complete item table. 2. List the name of all items in category GME. 3. List the item number, name and price for all products with an OnHand value over 10. 4. List the name and price for all products in the GME category or those with a price over $50. 5. List the name of all items in category GME that are located in storehouse number 3. 6. List the item number, name and price for all products in the category of GME, PZL, or TOY. 7. List the item number, name and price for all products in all categories except GME, PZL, or TOY. 8. List the item number, name, price and a new field named NewPrice that will add $5 to the current price. 9. Give the item number, name, and value (OnHand "Price) for each item in category GME. 10. Show the complete item table. Sort the results by category and within category by item number. 11. List the item number, name, and price for all toys that are over $100. Rename the ItemName field to be named ProductName. Sort in descending order by Price. 12. How many products are in the Item table? 13. What is the total, average, highest and lowest price of all products? 14. What is the total, average, highest and lowest price of all products by category? List the category name first. Sort by category in ascending order