Employees earning more than their manager
Employees earning more than their manager
HR is reviewing compensation anomalies: sometimes an employee earns more than their direct manager. Find all such employees and return their ID and name.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| employee_id | name |
|---|---|
| 5 | Eve |
| 6 | Frank |
| 8 | Henry |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid