Skip to content
LakeBench
ProblemsCommunityPricing
Sign inStart practicing

Employees without a manager

SQL data engineering interview problem. Difficulty: beginner. Pattern: Missing Data. About 8 minutes. Free to practice.

Find employees with no manager (manager_id IS NULL). Columns: employee_id, name. Order by employee_id.

Requirements

  • Exactly one root employee exists in the seed data.

Constraints

  • Return exactly these columns: employee_id, name.

Examples

Input: employees employee_id | name | manager_id 1 | Alice Chen | NULL 2 | Bob Kumar | 1 3 | Dan Park | 1 5 | Omar Ali | 1 Output: employee_id | name 1 | Alice Chen Why this passes: Only Alice has a NULL manager_id.

Topics: lakebench, sql, null, is null.

More SQL interview questions · All interview problems · Learn data engineering

beginner

Employees without a manager

Interview-style drill: Find employees whose manager_id is NULL.

Find employees with no manager (`manager_id IS NULL`). Columns: `employee_id`, `name`. Order by `employee_id`.