Highest and Lowest Cloud Costs
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
Which line items in `cloud_costs` sit at the very top and the very bottom of the whole bill? A billing analyst wants each one with its cost ID, amount and service name, plus a `cost_type` reading 'Highest Cost' or 'Lowest Cost'.
Summary
The extremes in cloud spending.
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