Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Identify the customer who incurred the highest daily total order cost between February 1 , 2 0 1 9 , and May 1 , 2
Identify the customer who incurred the highest daily total order cost between February and May If a customer had multiple orders on a given day, sum the order costs for that day. Output the customer's first name, the total cost of their items, and the corresponding date. Assume that each customer's first name in the dataset is unique.
Tables Schema as Below:
customers
columnName dataType
id INT
firstname VARCHAR
lastname VARCHAR
city VARCHAR
address VARCHAR
phonenumber VARCHAR
orders
columnName dataType
id INT
custid INT
orderdate DATE
orderdetails VARCHAR
totalordercost INT
Date is in the format yyyymmdd
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