00:00

1006. Recent Non-Deleted Direct Messages

MediumSQLITE7 / 1584

Relevant companies

1006. Recent Non-Deleted Direct Messages

Medium7 / 1584

Relevant companies

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a Customer Experience agent at LinkedIn. A user has reported a bug causing messages to occasionally not render correctly. To investigate, you need to pull a list of all direct messages sent on or after August 1st, 2025, that have not been deleted by the user.

Your task is to query the messages table to get a list of all messages that meet these criteria. The list should include the message ID, sender ID, recipient ID, the time it was sent, and its current status.

To make it easier to find the most recent messages related to the bug report, the list should be sorted with the newest messages first.

Schema: messages

Column Name	Type
message_id	INTEGER
sender_user_id

Business Problem

To make it easier to find the most recent messages related to the bug report, the list should be sorted with the newest messages first.

Schema: messages

Column Name	Type
message_id	INTEGER
sender_user_id

Recent Non-Deleted Direct Messages — SQL Medium | Let's Data Science | Let's Data Science

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

1006. Recent Non-Deleted Direct Messages

Relevant companies

Tags

1006. Recent Non-Deleted Direct Messages

Relevant companies

Tags

Sign in to Practice