What is the average price of all items purchased? How many orders did each customer make? Use the Order Item table. Select the customer id, number of orders they made, and the sum of their orders.

SQL

What is the average price of all items purchased?

Return the total number of items purchased.

How many orders did each customer make? Use the Order Item table. Select the customer id, number of orders they made, and the sum of their orders.

From the items ordered table, select the item, maximum price, and minimum price for each specific item in the table. Only display the results if the maximum price for one of the items is greater than 190.00.

Select the item and price for all of the items in the items ordered table where the price is greater than 10.00. Display the results in ascending order based on the price