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. (Don't 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!