TikTok SQL interview questions
Short-video engagement — views, creators and virality. Practice reconstructed TikTok-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.
pythonsqlpandaseasy3medium8hard5
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: 2–3 SQL questions in a shared editor (~45 min)
- 3.Onsite: SQL / Python coding, product-sense metrics case, behavioral
- › Fast iteration: expect several short questions back to back.
most-tested topics
JOIN
4
GROUP BY
2
SUM
2
multi-join
2
strings
1
parsing
1
Based on 16 reconstructed TikTok-style questions.
practice path
1 free · 15 Protype
level
- 1Extract hashtagspythoneasy
- 2Most used soundssqleasy
- 3Videos posted per creatorsqleasy
- 4Average watch percentagepandasmedium
- 5Coins earned per creatorsqlmedium
- 6Creators without giftssqlmedium
- 7Engagement leaderboardpandasmedium
- 8Feed deduplicationpythonmedium
- 9Like rate by soundsqlmedium
- 10Video completion ratesqlmedium
- 11Watch time per countrysqlmedium
- 12Follower conversion after viewingsqlhard
- 13Gifting rank within countrysqlhard
- 14Rolling 3-day coin totalpandashard
- 15Top k trending soundspythonhard
- 16Top video per creatorsqlhard
Unlock all 16 TikTok questions with Pro.
upgrade