Average Spending by Account Status
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
- L3
Interview Prompt
Finance's lifetime value model compares account statuses by how much their users spend over their lifetime. Using the users and transactions tables, show each account status with the average lifetime spend per user.
Summary
Average per-user lifetime spending segmented by account status
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