At Meta, the Messaging team wants to flag unusually high repeat sends between the same sender-recipient pair within a day. Write a SQL query to identify users who sent more than 3 messages to the same recipient in a single day.
sender_id, recipient_id, and calendar day derived from sent_at.message_date, sender_id, and recipient_id.| Column | Type | Description |
|---|---|---|
| message_idPK | INT | Unique message event identifier |
| sender_id | INT | User who sent the message |
| recipient_id | INT | User who received the message |
| sent_at | TIMESTAMP | Timestamp when the message was sent |
| message_surface | VARCHAR(50) | Meta surface that generated the message event |
| message_text | TEXT | Message body text |