Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
strftime. strftime(date, format) turns a date into text. In the format, %Y is the 4-digit year, %m the 2-digit month, %d the day, %H the hour and %M the minute. Labels like '2025-03' sort in date order, so they work well as month labels.
select signup_date, strftime(signup_date, '%d/%m/%Y') as uk_date from customers limit 5
The board deck needs completed orders per month, labelled like 2025-01. The AI assistant's chart has a single bar labelled 2025-00.
AI assistant: “I labelled each completed order with its year and month, then counted orders per label.”
Run the AI query, then fix it so it returns month (text like '2025-01') and orders (completed orders that month), one row per month, sorted by month.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe