Task $1$: List the item ID$,$ description, and price for all items.

Task $2$: List all rows and columns for the complete INVOICES table.

Task $3$: List the first name, last name, and credit limit of customers with credit limits of $$1,000$ or more.

Task $4$: List the invoice number for each order placed by customer number $125$ on $2021-11-15.$

If you need help, use the discussion of the DATE data type in Figure $3-16$ in Module $3.$

Task $5$: List the customer ID$,$ the first name, and the last name of each customer represented by sales rep $10$ or sales rep $15.$

Task $6$: List the item ID and description of each item that is not in category HOR.

Task $7$: List the item ID$,$ description, and number of units on hand for each item that has between $10$ and $30$ units on hand, including both $10$ and $30.$

Task $8$: List the item ID$,$ description, and on$-$hand value $($units on hand $*$ unit price$)$ of each item in category CAT. $($On$-$hand value is technically units on hand $*$ cost$,$ but there is no COST column in the ITEM table$).$ Assign the name ON$\_$HAND$\_$VALUE to the computed column.

Task $9$: List the item ID$,$ description, and on$-$hand value for each item where on$-$hand value is at least $$1,500.$ Assign the name ON$\_$HAND$\_$VALUE to the computed column.

Task $10$: Use the IN operator to list the item ID and description of each item in category FSH or BRD$.$

Task $11$: Find the ID$,$ first name, and last name of each customer whose first name begins with the letter S$.$

Task $12$: List all details about all items. Order the output by description.

Task $13$: List all details about all items. Order the output by item ID within location. $($That is$,$ order the output by location and then by item ID$.)$

Task $14$: How many customers have balances that are more than their credit limits$?$

Task $15$: Find the total of the balances for all customers represented by sales rep $10$ with balances that are less than their credit limits

Task $16$: List the item ID$,$ description, and on$-$hand value of each item whose number of units on hand is more than the average number of units on hand for all items.

Use a sub$-$query.

Task $17$: What is the price of the least expensive item in the database?

Task $18$: What is the item ID$,$ description, and price of the least expensive item in the database?

Use a sub$-$query.

Task $19$: List the REP$\_$ID and the corresponding sum of the balances, as BALANCE, of all customers for each sales rep. Order and group the results by sales rep ID$.$

Task $20$: 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 more than $$150.$

The results should display the REP$\_$ID and BALANCE column headers. Order the results by sales REP$\_$ID$.$

Task $21$: List the item ID$,$ description, and category of all items that are in the DOG or CAT category and contain the word Small in the description

Task $22$: KimTay Pet Supplies is considering discounting the price of all items by $10$ percent. List the item ID$,$ description, price, and discounted price for all items. Use DISCOUNTED$\_$PRICE as the name for the computed column.

The management of KimTay Pet Supplies $($a supplier of pet supplies, food, and

accessories located in Cody, Wyoming$)$ has determined that the company's recent

growth no longer makes it feasible to maintain customer, invoice, and inventory data

using its manual systems. In addition, KimTay Pet Supplies wants to build an

Internet presence. With the data stored in a database, management will be able to

ensure that the data is up$-$to$-$date and more accurate than in the current manual

systems. In addition, managers will be able to obtain answers to their questions

concerning the data in the database easily and quickly, with the option of producing

a variety of useful reports.

The CUSTOMER table maintains information about each customer, such as their ID$,$

first and last name, address, balance, and credit limit$.$

CUSTOMER table