Same First and Last Reply Target
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We're auditing how conversations open and close in each team chat channel. For every channel, month by month, return who received the first message and who received the last message.
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 and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision