Same First and Last Reply Target
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
Something odd turned up in messaging analytics. Find users whose first and last message in a channel on the same day were sent to the same recipient. Show the sender, recipient, and the date.
Summary
They started and ended the month messaging the same person.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision