Medium
WHERE
Pro Challenge

Department 5 Salary Filter 90000

Find employees in department 5 earning at least 90000. 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 5 earning at least 90000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.

Difficulty
Intermediate
SQL concept
WHERE