easy · ~8 min
E-commerce operations needs a daily order volume report covering every day in calendar (all 30 days of June 2024).
calendar
day
order_count
0
Input contract: day is unique and non-null in calendar. order_id is unique and non-null in orders; order_date is non-null and may have zero, one, or multiple rows for any calendar day.
order_id
orders
order_date