Table 1: tweets
***_**** | ***_**** ----------------+-------------------------- ****_** | ****** *****_** | ****** *****_*****_** | ****** *******_** | ********* ******* | *******(280) -- *** ** 280 *****
Question 191
Premium Access
Sign in or upgrade to practice this question with full datasets, official solutions, and guided walkthroughs.
***********
Table 1: tweets
***_**** | ***_**** ----------------+-------------------------- ****_** | ****** *****_** | ****** *****_*****_** | ****** *******_** | ********* ******* | *******(280) -- *** ** 280 *****
Table 2: twitter_experiment_users
***** **** **** **** ******** **** * ********* ***** ** *** *** **** ** *******. * **** *** **** ****** ** ****** ********* ** ******* ***** ** * ****** **********.
***_**** | ***_**** --------------+-------------------------- ***_** | ****** ****_** | ****** **_********* | *******
Sample results
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
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.
10:00
Run your query to preview results here.