00:00

2012. Latest Message per Sender–Recipient Pair

MediumSQLITE75 / 1584

Relevant companies

2012. Latest Message per Sender–Recipient Pair

Medium75 / 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 Trust & Safety Analyst at Meta. The team needs the latest direct message between each pair to prioritize case reviews. Your task is to provide, for each sender–recipient pair, the most recent message with its send time and delivery status. Exclude messages that were removed. Sort by the smallest sender identifier, then by the smallest recipient identifier; break ties by the smallest message identifier.

Schema: messages

Column Name	Type
message_id	INTEGER
sender_user_id	INTEGER
recipient_user_id	INTEGER

Business Problem

Schema: messages

Column Name	Type
message_id	INTEGER
sender_user_id	INTEGER
recipient_user_id	INTEGER

Latest Message per Sender–Recipient Pair — 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

sender_user_id	recipient_user_id	message_id	sent_at	status	message_rank
1	4	2	2025-04-10 02:40:32	delivered	1
1	33	1	2025-04-18 02:49:41	delivered	1
2	5

sender_user_id	recipient_user_id	message_id	sent_at	status	message_rank
1	4	2	2025-04-10 02:40:32	delivered	1
1	33	1	2025-04-18 02:49:41	delivered	1
2	5

2012. Latest Message per Sender–Recipient Pair

Relevant companies

Tags

2012. Latest Message per Sender–Recipient Pair

Relevant companies

Tags

Sign in to Practice