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.DATE '2024-06-21' as the reference date for the seven-day period.2024-06-15 onward through, but excluding, 2024-06-22.| 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 |