Analytical SQL · SQL problem
Daily Signups, Quiet Days Included
A free sql problem from the Dates, Time Series, Gaps and Islands skill. Read it here, then solve it in the app.
- Easy
- SQL problem
- Free
The problem
Marketing's launch-week chart shows signups per day for Monday, March 2 through Sunday, March 8,
2026 (UTC days). Every day of that week must appear - a day without signups shows 0 - and
signups outside the week don't count.
| column | meaning |
|---|---|
day | the date |
signups | how many people signed up that day |
Sort by day.
How it's graded
- Your SQL runs on PostgreSQL 18. Run compares your rows with the expected rows on the sample data; Submit runs it against hidden datasets built to catch the classic mistakes.
- Stuck? Hints come in four steps, from a nudge to a code skeleton, each costing part of the points.
More problems in Dates, Time Series, Gaps and Islands
Write the query Daily Signups, Quiet Days Included free
No card needed. Lessons, practice questions and easy problems are free forever.
Free plan, no card · 7-day Pro trial · Cancel anytime