Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Dates: month() and date_trunc(). month(date) gives the month number, 1 to 12. year(date) and day(date) work the same way. date_trunc('month', date) keeps a full date but moves it to the 1st of its month. You can GROUP BY and ORDER BY either one.
select month(signup_date) as signup_month, count(*) as customers from customers group by 1 order by 1
Finance wants to see how completed revenue moved through 2025, one row per month.
Return the month as a number (1 to 12) and completed revenue for that month (2 decimals), January first.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe