Given a table of tweets, calculate the number of tweets posted per user in 2022, then show how many users posted each tweet count. Output the tweet count bucket and the number of users in that bucket.
Schema
tweets
tweet_idINTEGER
user_idINTEGER
msgVARCHAR
tweet_dateDATETIME
Target output
Target output
| tweet_bucket | users_num |
|---|
| 1 | 10 |
| 2 | 5 |
| 3 | 2 |