Longest Gap Between Token Events
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
The security team is auditing credentials that rotate on a fixed expiry. Looking only at tokens that carry an expiration date, find the longest stretch between one token being issued and the next, and the longest stretch between consecutive expirations. Return both maximum gaps.
Summary
The longest gap between token events.
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