Home
/
Questions
/
Coding
/
Employees earning above their department average
caseSQL
Coding question · Top N Per Group
Medium
Asked at LinkedIn
Employees earning above their department average
Correlated subquery to compare each row against a group aggregate.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Which departments have no employees?
Next →
Top 2 earners per department (DENSE_RANK)