Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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