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.