Loading page content

Practice Interview Roadmap Resources Leaderboard

Sign In Get Started Free

Department 2 Salary Filter 60000 SQL Challenge | SQL Master

Medium

WHERE

Pro Challenge

Department 2 Salary Filter 60000

Find employees in department 2 earning at least 60000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Find employees in department 2 earning at least 60000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.

Difficulty: Intermediate
SQL concept: WHERE

Related SQL challenges

Filter High EarnersBeginner Engineering Department EmployeesBeginner Find Employees Without ManagersBeginner Employees in a Salary RangeBeginner

More Intermediate challenges

Previous challengeDepartment 1 Salary Filter 90000 Next challengeEmployee Names Starting With A