Question: 4. Write a SQL statement that returns one row for every customer that has orders with these columns: The first_name from the Customers table A

 4. Write a SQL statement that returns one row for every

4. Write a SQL statement that returns one row for every customer that has orders with these columns: The first_name from the Customers table A count of the number of orders Show the most expensive item_price that was purchased per customer Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the highest priced item column (8 points) HINT You will need to join 3 tables: orders, order_items and customers 5. Modify the solution to exercise 4 so it only counts and finds max priced line items that have an item_price value that's greater than 300

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 Databases Questions!