Skip to content
LakeBench
ProblemsCommunityPricing
Sign inStart practicing

Filter Engineering salaries

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

From employees, return every row where department = 'Engineering' and salary > 80000. Columns: employee_id, name, department, salary, hire_date. Order by salary descending, then employee_id.

Requirements

  • Engineering employees above 80000, highest salary first.

Constraints

  • Department names are title case strings.
  • Return exactly these columns: employee_id, name, department, salary, hire_date.

Examples

Input: employees employee_id | name | department | salary | hire_date 1 | Alice Chen | Engineering | 120000 | 2022-01-15 2 | Bob Kumar | Engineering | 95000 | 2023-03-01 3 | Dan Park | Engineering | 110000 | 2021-11-20 4 | Eve Ng | Engineering | 95000 | 2024-01-05 5 | Omar Ali | Sales | 105000 | 2020-06-01 6 | Max Reed | Sales | NULL | 2023-12-01 Output: employee_id | name | department | salary | hire_date 1 | Alice Chen | Engineering | 120000 | 2022-01-15 3 | Dan Park | Engineering | 110000 | 2021-11-20 2 | Bob Kumar | Engineering | 95000 | 2023-03-01 4 | Eve Ng | Engineering | 95000 | 2024-01-05 Why this passes: Omar is over 80000 but Sales. Max has NULL salary. All four Engineering rows clear the salary bar.

Topics: lakebench, sql, where, filter.

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

beginner

Filter Engineering salaries

Interview-style drill: Filter employees in Engineering earning more than 80000.

From `employees`, return every row where `department = 'Engineering'` and `salary > 80000`. Columns: `employee_id`, `name`, `department`, `salary`, `hire_date`. Order by `salary` descending, then `employee_id`.