Skip to interview prep
Apexed

Employees who earn more than their manager

JoinsMedium

Return the name of employees whose salary is higher than their direct manager's, ordered by name. Return an empty result if there are none.

Tables

  • departments: id, name
  • employees: id, name, department_id, manager_id, salary, hired_on

Row order is checked. Column names do not have to match, but the number of columns and the values do.

Tab indents · Ctrl/⌘ + Enter runs · Esc then Tab leaves the editor

Run your query. It is checked against the expected result on the same data.

Solution

Queries run only in your browser on a private SQLite database (sql.js from a public CDN). Nothing is sent to Apexed.

Employees who earn more than their manager: SQL interview practice — Apexed