Build a calendar from the first to the last order date (kite shop)
Create a table with one row for every day from the earliest to the latest order date, including days with no orders.
- Level
- intermediate
- Time
- ~9 min
- Task
- Build the query
- Access
- Pro
Checking your access…
About this exercise
What you'll practise
Use list functions and let variables to generate a table instead of transforming one.
The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.
Input
- Orders (table)
- OrderID: text
- Customer: text
- Region: text
- Product: text
- Qty: number
- UnitPrice: number
- OrderDate: text
- Status: text
Expected output columns
Date (date)