Histogram of Tweets by Posting Frequency

Twitter

Foundations Track · Medium · 25 min

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...

Foundations Track

Medium

25 min

aggregation

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Back to practice

Objective

Practice aggregation through a Twitter-tagged business scenario.

Approach

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

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 bucket and the number of Twitter users who fall into that bucket. In other words, group the users by the number of tweets they posted in 2022 and count the number of users in each group. [Full Description]

tweets

tweet_id INTEGER PRIMARY KEY

user_id INTEGER NOT NULL

msg TEXT

tweet_date DATE NOT NULL

Editor

SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.