Most Efficient Region by Token Usage
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
- L4
Interview Prompt
Each row of `api_tokens` is one access token with its `scope`, its issued and expiration dates, and the requests it has served. Per scope, report the average lifetime in days, the total requests in thousands, and requests per day as average requests over average lifetime.
Summary
Some regions squeeze more out of every token.
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