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 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
Get step-by-step solutions from verified subject matter experts
