Employees Earning Above 100000

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

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

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

Difficulty: Beginner
SQL concept: WHERE

This Pro challenge keeps its schema, dataset and solution behind subscription access. No protected answer content is included in public SEO data.