TikTok data interview guide
Short-video engagement — views, creators and virality.
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
SUM
2
multi-join
2
GROUP BY
2
groupby
1
derived columns
1
Based on 16 reconstructed TikTok-style questions.
practice path
0 free · 16 Pro- 1Average watch percentagepandasMedium
- 2Coins earned per creatorsqlMedium
- 3Creators without giftssqlMedium
- 4Engagement leaderboardpandasMedium
- 5Extract hashtagspythonEasy
- 6Feed deduplicationpythonMedium
- 7Follower conversion after viewingsqlHard
- 8Gifting rank within countrysqlHard
- 9Like rate by soundsqlMedium
- 10Most used soundssqlEasy
- 11Rolling 3-day coin totalpandasHard
- 12Top k trending soundspythonHard
- 13Top video per creatorsqlHard
- 14Video completion ratesqlMedium
- 15Videos posted per creatorsqlEasy
- 16Watch time per countrysqlMedium
Unlock all 16 TikTok questions with Pro.
upgrade