Best in Show

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

We log a range of performance metrics for each department, and the same reading sometimes gets recorded more than once. For each department, surface its highest metric value as a single entry, showing the department, the metric name, the value, and its standing within the department.

Summary

Every department has a peak. Name it, once each.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.