Three Peaks

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

L4

Interview Prompt

`cost_allocs` records cloud spend as individual allocations, each tagged to a team and a billing `period`, so a team's monthly cost is everything allocated to it in that period. Surface the three highest monthly cost amounts for each team.

Summary

Every team's steepest months, and nothing below them.

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