Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Utilizing the Customer-Order Database discussed in class, return the following results: 1 What is the average price of all items purchased by all customers? 2.
Utilizing the Customer-Order Database discussed in class, return the following results: 1 What is the average price of all items purchased by all customers? 2. Return the total number of items purchased 3 How many orders did each customer make? Use the Order_ltem table. Select the customerid, number of orders they made, and the sum of their orders. 4 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. 5 Select the item and price for all of the items in the items_ordered table that the price is greater than 10.00. Display the results in Ascending order based on the price
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started