Employees who earn more than their manager

Easy

Question

The employees table stores each person together with the id of their manager (manager_id). The top boss has no manager, so the value is NULL.

Find the employees who earn MORE than their own manager.

Return employee, salary, manager and manager_salary. The order of the rows does not matter.

join
self join
payroll

Read first: Lesson 44, SQL joins: inner, left, anti-join and self-join

Tables

1 table

These are the example rows. Run uses only these rows. Submit also tests your query on a second set of rows that you cannot see.

employees4 columns · 9 rowsnot run yet

CREATE TABLE employees (id INTEGER PRIMARY KEY, name TEXT NOT NULL, salary INTEGER NOT NULL, manager_id INTEGER REFERENCES employees(id));

Example rows of the employees table
id	name	salary	manager_id
1	Rajesh	300000	NULL
2	Sunita	180000	1
3	Vikram	200000	1
4	Anjali	190000	2
5	Karan	180000	2
6	Leela	150000	3
7	Manoj	210000	3
8	Nisha	120000	6
9	Omkar	155000	6

About this SQL

A table can be joined to itself in every database: give it two different aliases. The boss with a NULL manager_id never matches any row in an inner join, because NULL is not equal to anything.

SQLite

Opening the code editor…

Result

Run shows what your query gives on the example rows.Submit checks it on the example rows and on a hidden set of rows.

SQL · ready