SQL Quest › SQL Interview Prep › TikTok
Two sources three years apart agree on a live SQL screen on HackerRank — joins and window functions, activation and engagement questions, ties broken the way the prompt says.
16 practice challenges · 4 Easy / 5 Medium / 7 Hard · your first 10 solves free · runs in the browser
What is sourced: TikTok does not publish its interview format, so every specific about their process on this page is what candidates and prep guides described publicly — each one carries its source and the date it showed. Formats change; treat them as reported, not official. What is ours: the practice questions are SQL Quest challenges, picked because their SQL matches the patterns those sources report. They are not questions TikTok has asked.
TikTok does not publish the format. Each row is what candidates and prep guides have described publicly, with its source; where sources disagree, the row says so. Formats change — treat every specific as reported, not official.
| Roles | Data Scientist, Data Analyst and Data Engineer.[2] |
|---|---|
| Data science stages | Recruiter screen, a hiring-manager screen, a technical loop of three or four rounds of about 45 minutes each plus behavioural rounds, then a final manager conversation; all virtual.[1] |
| Technical screen | A 45–60 minute screen on HackerRank covering SQL alongside statistics and probability.[2] |
| Data analyst screen | A 2022 candidate report describes a 30-minute live HackerRank screen: standard joins and window functions plus a short case.[4] |
Sources: Exponent — TikTok Data Scientist interview guide (updated mid-2026); DataLemur — TikTok SQL interview questions and data science guide (5 Jan 2025); DataLemur — second-day confirmation question (undated); Blind — TikTok data analyst screen report (6 Feb 2022). Accessed 13 Sep 2026.
Reported most often, in order
Difficulty: Reported as medium, with some reports of medium-to-hard. The data is videos (uploads, likes, dates), user interactions, sign-up and confirmation events, and creator cohorts.
Our TikTok practice set, by skill
The 16 SQL Quest challenges tagged TikTok, resolved onto the nine Skillmap skills. A challenge exercises several skills, so shares do not sum to 100%. This is the composition of the practice set on this page, not a measurement of TikTok’s interview.
Shapes candidates and guides report (paraphrased)
Practise now — SQL Quest challenges matched to those patterns
Our challenges, chosen because their SQL matches the shapes above; not questions TikTok has asked. Each card opens the challenge in the browser — no signup; a card marked Free can be one of your 10 free challenge solves.
Skillmap
Ten questions, no signup. You get a readiness score weighted to the SQL this page covers, your Skillmap across joins, window functions, aggregation and the rest, and the weakest skill to practise first.
Drill the skills the TikTok set leans on, one at a time: GROUP BY exercises · Window function practice · CTE practice · Date function practice · JOIN practice — or browse every SQL practice question.
Every question in the TikTok set, one page each with the schema and a hint: Monthly Order Count · How Many Genres Do We Cover? (DISTINCT) · LEFT JOIN: Watch the NULLs Appear · Counting Across a JOIN · Inactive Customers by Tier · Month-over-Month Customer Growth · RANK vs DENSE_RANK Side-by-Side · Most Recent Order Per Customer (ROW_NUMBER) · The Previous Order's Total (LAG) · Order Sessionization by Customer · Rank Movies by Rating · Daily Active Customers · RANK vs DENSE_RANK: Rating Gaps · Order Funnel Conversion · Month-over-Month Revenue Growth · Customer Retention Cohort.
No signup, no card. Your first 10 challenge solves are free; the Skillmap shows what to fix before the interview.
Start the TikTok set — free