Twitter 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.
Explore 3 Twitter-tagged SQL scenarios focused on aggregation, filtering.
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
3
Estimated prep time
85 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Twitter-tagged set.
Aggregation
2
Filtering
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.
Histogram of Tweets by Posting Frequency
Practice aggregation through a Twitter-tagged business scenario.
02 Medium Twitter Tweets Rolling Averages
Practice aggregation through a Twitter-tagged business scenario.
Top Department Salaries
Practice filtering through a Twitter-tagged business scenario.
Question list
The current Twitter-tagged list with learning objectives and your latest status.
Histogram of Tweets by Posting Frequency
Assume you're given a table Twitter tweet data, write a query to obtain a histogram of tweets posted per user in 2022. Output the tweet count per user as the...
Practice aggregation through a Twitter-tagged business scenario.
02 Medium Twitter Tweets Rolling Averages
-- tweets rolling average -- WITH tweet_posts AS ( SELECT user_id, tweet_date, COUNT(tweet_id) AS tweet_count FROM tweets GROUP BY user_id, tweet_date ) SELE...
Practice aggregation through a Twitter-tagged business scenario.
Top Department Salaries
Twitter wants a scorecard for top department salaries. The compensation team wants the top salary levels in each department. Rank salaries within each depart...
Practice filtering through a Twitter-tagged business scenario.