TikTok practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
TikTok
Explore 11 TikTok-tagged SQL scenarios focused on query basics, aggregation, date functions.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
11
Estimated prep time
215 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current TikTok-tagged set.
Query basics
11
Aggregation
2
Date functions
2
Analytics reporting
1
Filtering
1
Joins
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
First Customer Transaction
Practice query basics through a TikTok-tagged business scenario.
2024 App Click Volume
Practice query basics through a TikTok-tagged business scenario.
Creators With Multiple 2024 Posts
Practice query basics through a TikTok-tagged business scenario.
Question list
The current TikTok-tagged list with learning objectives and your latest status.
First Customer Transaction
TikTok is reviewing first customer transaction through a scorecard. Return each user_id and transaction_date for the first transaction made by that user. Sor...
Practice query basics through a TikTok-tagged business scenario.
2024 App Click Volume
TikTok wants a scorecard for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Practice query basics through a TikTok-tagged business scenario.
Creators With Multiple 2024 Posts
TikTok wants a trend check for creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a TikTok-tagged business scenario.
Frequent Support Callers
Use this TikTok scorecard to work on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 calls. Sort by pol...
Practice query basics through a TikTok-tagged business scenario.
Creators With Multiple 2024 Posts
Use this TikTok manager brief to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a TikTok-tagged business scenario.
Late Shipment Rate By Carrier
TikTok is reviewing late shipment rate by carrier through a operations review. Return the percentage of shipments that arrived late by carrier_name. Output c...
Practice query basics through a TikTok-tagged business scenario.
Second-highest Salary
TikTok wants a manager brief for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.
Practice query basics through a TikTok-tagged business scenario.
Primary Department For Each Employee
At TikTok, analysts are preparing a operations review focused on primary department for each employee. Return each employee_id and whether the employee met q...
Practice query basics through a TikTok-tagged business scenario.
Seven-Day Trial Conversion
The growth team wants to compare acquisition channels for January trial signups. For each acquisition_channel, return the number of users who converted withi...
Practice query basics through a TikTok-tagged business scenario.
One-Month Creator Retention
Growth wants a basic cohort view for creator retention. For signup_month values from 2024-01-01 through 2024-03-01, return the cohort size, the number of cre...
Practice query basics through a TikTok-tagged business scenario.
Rolling Three-day Earnings
At TikTok, analysts are preparing a trend check focused on rolling three-day earnings. Return each user_id, transaction_date, and rolling_3_day_earnings base...
Practice query basics through a TikTok-tagged business scenario.