Employees Earning Above 70000

List employee names and salaries above 70000, ordered by salary descending. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

List employee names and salaries above 70000, ordered by salary descending. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.

Difficulty: Beginner
SQL concept: WHERE