SQL Quest › SQL Interview Questions › Joins

Management Hierarchy Overview

MediumFreeQuerying BasicsJoinsSubqueries & CTEsNULL HandlingConditional Logic

For each employee, show: name, position, salary, manager_name (or 'No Manager' for top-level), and role_type ('Manager' if they have any direct reports, 'Individual Contributor' otherwise). Sort by salary descending.

Solve it in the browser editor →

Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".

Schema

employees

emp_id	name	department	position	salary	hire_date	manager_id	performance_rating
1	Alice Johnson	Engineering	Senior Developer	95000	2019-03-15	5	4.5
2	Bob Smith	Engineering	Developer	75000	2020-06-01	1	3.8
3	Carol Williams	Marketing	Marketing Manager	85000	2018-09-20	NULL	4.2

Expected output: All employees with manager name and whether they manage others

Hint

LEFT JOIN employees m ON e.manager_id = m.emp_id gives manager name. EXISTS (SELECT 1 FROM employees sub WHERE sub.manager_id = e.emp_id) checks for direct reports

Concepts

SELECT LEFT JOIN EXISTS Subquery COALESCE Self-Join CASE Self-Join + EXISTS

Practise the topic: SQL practice questions · JOIN practice · CTE practice · NULL handling practice · CASE WHEN practice

In these company practice sets

Google · Snowflake

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Management Hierarchy Overview

Schema

Hint

Concepts

In these company practice sets

Related questions