SQLQuokka
Start practicing
QuestionsLearnSandboxFeaturesRoadmapFAQ

Active Users in Last 7 Days

Unsolved

Find all distinct user IDs who had at least one activity entry within the 7-day inclusive window from '2025-03-01' through '2025-03-07'. Return column `user_id`, ordered ascending.

SQL Query Editor (Ctrl+Enter to run)
0 characters · Valid
Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments
Asked By:
🏢 Meta🏢 Netflix🏢 Uber

Submission History

Your recent query executions and answer checks

Execution Pipeline:
FROM Activity
Full source dataset
10 rows total
Ready. Type a query to see live execution.
Clause: Auto-Sync · AlaSQL Engine