Single Table SQL Assignment 1. Points: 40 Points 2. Due Date: 02/03 by 11:59PM 3. Turn In: SQL commands for the following query questions. Save your SQL file and submit it through Canvas. You need to use comments to indicate which query is for which question. Query Questions (5 points per question): Use the TAL database in your Pratt textbook ("A Guide to SQL") to answer the following questions: 1. List the number and description of each item whose price is between $50 and $200. 2. How many customers have a balance at most $800 ? 3. How many customers have either "Shop" or "Store" in the names? 4. List the sum of the balances of all customers for each sales rep but restrict the output to those sales reps for which the sum is less than $10,000. 5. List the item number, description, and number of units on hand for each item that is stored in storehouse 1 or 2. 6. Generate a list of all items not in the puzzle category with the following details, item number, description, on hand quantity and price. Order the output by part description. 7. How many parts on hand for each store house? 8. What is the price of the most expensive part? 9. What is the last name and commission rate for a rep called Megan