Metric Range Per Group

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

Domain

SQL

Difficulty

easy

Seniority

senior

Problem

HR suspects some departments have much wider performance variance than others. For each department, compute the spread between its highest and lowest metric values, ordered alphabetically by department.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.