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_idname
5Eve
6Frank
8Henry

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid