Table 1: subscription
**** * **** ********** ** ****** ***** *****.
***_**** | ***_**** -------------------+-------------------------- ************_** | ****** ************_** | **** ********_** | ******
Question 169
Same day streams
Premium Access
Unlock this Tiktok interview question.
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
- 230+ interview questions
- Official solutions
- SQL, Python, and R tracks
- ***** * ***** ** ****** *** ****** ** ******* ** *** **** *** **** * **** ********** ** *** ***** 7 **** ** ****** 2021 (2021-08-01 ** 2021-08-07, ***********).
Table 2: video_stream
****** ***** ********* ****.
***_**** | ***_**** ----------------------+-------------------------- ******_** | ****** ******_** | **** ******_** | ******* ******_******** | *******(20) -- '**** **', '***** **', '******* **', '****** **', '****' ********_** | ****** *******_******** | ******* ******_***** | ******* -- ****** ** ******* ****** *** ***** ***** ******* ********_******* | *******(20) -- **, **, **
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
5:00
Your results
Run your query to preview results here.