The creator_posts table has one row per post (tweet_id, user_id, tweet_date). Considering only posts dated in calendar year 2022, count how many posts each user published, then build a histogram: for every per-user post count (tweet_bucket), return how many users (users_num) published exactly that many posts. Users with no 2022 posts are not part of any bucket. Output columns: tweet_bucket, users_num. Order by tweet_bucket ascending.
Table: creator_posts
Schema of creator_posts| Column | Type |
|---|
| tweet_id | INTEGER |
| user_id | INTEGER |
| tweet_date | DATE |
Sample rows of creator_posts| tweet_id | user_id | tweet_date |
|---|
| 101 | 1 | 2022-01-10 |
| 102 | 1 | 2022-02-15 |
| 103 | 2 | 2022-03-20 |
| 104 | 3 | 2022-04-11 |
| 105 | 3 | 2022-05-12 |
| 106 | 3 | 2022-06-13 |
Expected output on the sample data| tweet_bucket | users_num |
|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |