Write SQL and Python, run instantly in your browser, and track your progress.
You are a Trust & Safety Analyst at Meta. The community support team needs to monitor member conversations to ensure platform guidelines are being followed and to assist with user inquiries.
Your task is to provide a list of direct messages showing who sent and received them, when they were sent, and their current state. Sort from newest to oldest.
| Column Name | Type |
|---|---|
| message_id | INTEGER |
| sender_user_id | INTEGER |
| recipient_user_id | INTEGER |
You are a Trust & Safety Analyst at Meta. The community support team needs to monitor member conversations to ensure platform guidelines are being followed and to assist with user inquiries.
Your task is to provide a list of direct messages showing who sent and received them, when they were sent, and their current state. Sort from newest to oldest.
| Column Name | Type |
|---|---|
| message_id | INTEGER |
| sender_user_id | INTEGER |
| recipient_user_id | INTEGER |
| sent_at |
| sent_at |
| TEXT |
| TEXT |
| content_text | TEXT |
| content_text | TEXT |
| status | TEXT |
| status | TEXT |
| message_id | sender_user_id | recipient_user_id | sent_at | content_text | status |
|---|---|---|---|---|---|
| 1 | 1 | 33 | 2025-04-18 02:49:41 | Hi! I'm working on something similar. Would love to chat! | delivered |
| 2 | 1 | 4 |
| message_id | sender_user_id | recipient_user_id | sent_at | content_text | status |
|---|---|---|---|---|---|
| 1 | 1 | 33 | 2025-04-18 02:49:41 | Hi! I'm working on something similar. Would love to chat! | delivered |
| 2 | 1 | 4 |
| message_id | sender_user_id | recipient_user_id | sent_at | status |
|---|---|---|---|---|
| 318 | 57 | 26 | 2025-08-31 15:13:30 | sent |
| 324 | 58 | 13 | 2025-08-31 14:27:41 | read |
| 19 | 4 | 9 | 2025-08-31 14:08:02 | read |
| message_id | sender_user_id | recipient_user_id | sent_at | status |
|---|---|---|---|---|
| 318 | 57 | 26 | 2025-08-31 15:13:30 | sent |
| 324 | 58 | 13 | 2025-08-31 14:27:41 | read |
| 19 | 4 | 9 | 2025-08-31 14:08:02 | read |
Showing first 5 of 337 rows. Direct messages sorted by most recent send time.
Showing first 5 of 337 rows. Direct messages sorted by most recent send time.
1. Output Columns:
2. Filtering:
3. Ordering:
1. Output Columns:
2. Filtering:
3. Ordering:
| 2025-04-10 02:40:32 |
| 2025-04-10 02:40:32 |
| Thanks for sharing that resource! Super helpful. |
| Thanks for sharing that resource! Super helpful. |
| delivered |
| delivered |
| 3 | 2 | 58 | 2025-07-04 22:32:15 | Quick question - what tools do you use for productivity? | read |
| 3 | 2 | 58 | 2025-07-04 22:32:15 | Quick question - what tools do you use for productivity? | read |
| 4 | 2 | 5 | 2025-04-24 01:06:27 | Hi there! Fellow Developer here. Love your work! | read |
| 4 | 2 | 5 | 2025-04-24 01:06:27 | Hi there! Fellow Developer here. Love your work! | read |
| 5 | 2 | 50 | 2025-08-22 06:30:27 | Hey! Saw your post about productivity. Really resonated with me. | delivered |
| 5 | 2 | 50 | 2025-08-22 06:30:27 | Hey! Saw your post about productivity. Really resonated with me. | delivered |
| 328 | 58 | 45 | 2025-08-31 02:04:08 | read |
| 328 | 58 | 45 | 2025-08-31 02:04:08 | read |
| 291 | 53 | 30 | 2025-08-30 14:49:31 | read |
| 291 | 53 | 30 | 2025-08-30 14:49:31 | read |