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

Use the IN operator to list the item number and description of each item in category GME or PZL$.$

Find the number and name of each customer whose name begins with the letter $"$C$."$

Lisi all details about all items. Order the output by description.

List all details about all items. Order the output by $...............$ ber within storehouse. $($That is$,$ order the output by storehouse and then by item number.$)$

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

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

List the item number, 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. $($Hint: Use a subquery.$)$

What is the price of the least expensive item in the database?

What is the item number, description, and price of the least expensive item in the database? $($Hint: Use a subquery.$)$

List the sum of the balances of all customers for each sales rep. Order and group the results by sales rep number.

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 $$5,000.$ Order the results by sales rep number.

List the item number of any item with an unknown description.