Question 11 to 20

Chapter 4 11. Find the number and name of each customer whose name begins with the letter "C." 12. List all details about all items. Order the output by description. 13. List all details about all items. Order the output by item number 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? 14. ind the total of the balances for all customers represented by sales rep 15 with balances that are less than their credit limits. 16. 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.) 17. What is the price of the least expensive item in the database? 18. What is the item number, description, and price of the least expensive item in the data- 19. List the sum of the balances of all customers for each sales rep. Order and group the 20. List the sum of the balances of all customers for each sales rep, but restrict the output to th 21. List the item number of any item with an unknown description. base? (Hint: Use a subquery.) results by sales rep number. sales reps for which the sum is more than $5,000. Order the results by sales rep number