Alert Severity
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
Offsets are showing up twice in topic after topic of the message stream. For each message, return its offset, the offset just before it in the same topic, how many different offsets the topic has reached so far, its position in the topic, and the fraction of messages so far that carried a new offset.
Summary
When the alarms go off, who screams loudest?
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