Videos With Zero Views
Find all videos that have received no views. Return the video_id and creator_id for each video with zero views, ordered by video_id ascending.
Tables: videos, video_views
SQL practice / TikTok
Free SQL interview practice
TikTok SQL interview questions. All free.
5 SQL practice questions in our TikTok 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.
1 Easy · 1 Easy–Medium · 2 Medium · 1 Hard
Independent practice resource. Not affiliated with or endorsed by TikTok.
Inside the TikTok set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
Joins 4 questionsAggregation 3 questionsWindow functions 2 questionsConditional logic 1 questionDates 1 questionNULL handling 1 question
7-Day Rolling Average of Daily Video Uploads
Calculate the 7-day rolling average of daily video uploads. For each day, return the upload_date, the count of videos uploaded that day (daily_count), and the rolling 7-day average (rolling_7d_avg). Use a window function to compute the rolling average. Order by upload_date.
Tables: videos
Top Creators by Engagement Rate
Identify the top 10 creators by engagement rate (engagements per view). For each creator, return: creator_id, creator_name, total_views, total_engagements, and engagement_rate. Only include creators with at least 1000 total views. Order by engagement_rate descending.
Tables: creators, videos, video_views, engagements
The bank
TikTok SQL questions. Start typing SQL.
5 TikTok problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Videos With Zero ViewsJoins, Aggregation, NULL handlingEasy5 min7-Day Rolling Average of Daily Video UploadsWindow functions, AggregationMedium10 minTop Creators by Engagement RateJoins, Aggregation, Window functionsHard15 minSecond Day ConfirmationJoins, DatesEasy–Medium8 minSignup Activation RateJoins, Conditional logicMedium10 minPractice TikTok SQL — 5 questions
How it works
Solve in the browser. Checked instantly.
- 1Pick a problemPractice questions for data science and analytics interviews, each with its own tables, difficulty, and time target.
- 2Write and run SQLA full database engine loads in the tab. No setup, nothing to install — query the practice dataset immediately.
- 3Submit for a verdictPass and move to the next problem. Miss and you unlock the expected output and a reference solution.
Your dataset
videos
video_id (INTEGER) · creator_id (INTEGER) · upload_date (DATE) · duration_seconds (INTEGER)
video_views
view_id (INTEGER) · video_id (INTEGER) · viewer_id (INTEGER) · view_date (DATE) · watch_duration_seconds (INTEGER)
5
TikTok questions
188
questions in the full bank
$0
free access
Solve one now. Build your solved history.
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 TikTok SQL freeExplore SQL questions by company.
188 SQL practice questions. 23 companies. Free access to every problem.