Your question is Top Meta Messengers Last 7 Days. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
On Meta messaging surfaces, growth analysts often monitor who is driving recent conversation volume as part of engagement diagnostics alongside AARRR funnel metrics. Write a SQL query to find the top 3 users who sent the most messages in the last 7 days.
messages table.sender_user_id sent in the last 7 days.sender_user_id and message_count.message_count descending, then sender_user_id ascending.| Column | Type | Description |
|---|---|---|
| message_idPK | INT | Unique message identifier |
| sender_user_id | INT | User who sent the message |
| recipient_user_id | INT | User who received the message |
| sent_at | TIMESTAMP | Timestamp when the message was sent |
| message_surface | VARCHAR(50) | Meta product surface where the message was sent |
| message_text | TEXT | Message content |