Peak Satisfaction
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
HR is preparing the annual engagement report and wants to see how each department scores on satisfaction. For the satisfaction_score metric, give each department its highest and lowest score along with how many measurements are on file, and list the departments from the highest peak score on down.
Summary
Which departments are winning on satisfaction?
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision