Top Metric per Department
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Problem
For each department, find the entry with the highest metric value, showing the department, metric name, value, and its rank within the department.
Summary
Peak performer in every department.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.