Peak Company

A hard 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

hard

Seniority

L5

Interview Prompt

The platform security team's capacity review keeps quoting peak token counts that nobody can reproduce, so for each token in `api_tokens` they want the most tokens that were live on any single day of that token's own active window, and the date that peak was hit. A token's active window runs from when it was issued until it expires.

Summary

Every token lived among others. Find the moment the crowd was largest.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision