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

L5

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.

Summary

The spread within each group.

Practice This Problem

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