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.
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
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 subquery.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps