Highest Total Daily Order Cost in a Date Range

Mediumsql

You are given a table named orders that records individual purchases. Each row has an order id, the id of the customer who placed it, the date it was placed, and the order amount. A customer can place more than one order on the same day.

For every customer and every day, the total daily cost is the sum of all amounts that customer spent on that day. Consider only orders whose order_date falls within the inclusive range from 2024-01-01 to 2024-01-31.

Return a single row with one column named max_daily_total holding the largest total daily cost across all customers and days in that range.

Example:

Input:

orders rows shown in the seed data

Output:

max_daily_total = 300.00

Reasoning:

Within the date range, customer 1 spent 100 + 150 = 250 on 2024-01-05 and 120 on 2024-01-20, while customer 2 spent 200 + 100 = 300 on 2024-01-10. The 1000.00 order on 2024-02-01 is outside the range and ignored. The largest daily total is 300.00.

Learn About topic

Contributors:

Deep-ML

Contribute