Easy
WHERE
Pro Challenge

Employees in Salary Band 85000–105000

Find employees whose salary is between 85000 and 105000, inclusive. Return columns: first_name, last_name, salary. Order results by: salary, id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Find employees whose salary is between 85000 and 105000, inclusive. Return columns: first_name, last_name, salary. Order results by: salary, id.

Difficulty
Beginner
SQL concept
WHERE