Question: Use aggregate functions to select the count of catalog items each supplier supplies. Use aggregate functions to select the count of customer orders. Use aggregate
Use aggregate functions to select the count of catalog items each supplier supplies.
Use aggregate functions to select the count of customer orders.
Use aggregate functions to select the count of orders per customer.
Use aggregate functions to select the count of the number of items in each customer order.
Use aggregate functions to select the average number of catalog items each supplier supplies.
Use aggregate functions to select the average number of item quantities in each customer orders.
Use aggregate functions and sub queries to select the difference between the average overall order item quantity and the average number of item quantities in each customer orders. Dont panic deep breaths
Use aggregate functions and sub queries to select the percentage of the total orders each customer has. Deep breaths and a glass of water
Turn in your new insert statements, all aggregate function queries, and results.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
