11 SQL practice questions in our Snap collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
8 Medium · 3 Hard
Independent practice resource. Not affiliated with or endorsed by Snap.
These topics come from the questions in this set. Pick one to open the matching problems.
Analyze time spent by Snap users aged 13-17, 18-24, 25-34, 35+. For each age group, show: age_group, send_time_minutes, open_time_minutes, and send_to_open_ratio. Focus on the past 30 days.
Identify users with active snap streaks of 7+ days in the past 30 days. Return: user_id, friend_id, current_streak_length, max_streak_in_period. A streak is broken if either user doesn't send a snap on a day (consecutive day requirement).
Identify VIP users who have sent 100+ snaps per week in the past 4 weeks. Return: user_id, username, avg_snaps_per_week, max_week_snaps, account_age_days. These are power users we want to measure engagement for.
11 Snap problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
user_id (INTEGER) · birth_date (DATE) · country (VARCHAR)
event_id (INTEGER) · user_id (INTEGER) · event_type (VARCHAR) · snap_type (VARCHAR) · event_timestamp (TIMESTAMP) · duration_seconds (INTEGER)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Snap SQL free188 SQL practice questions. 23 companies. Free access to every problem.