Employees Earning Over 100K

Problem

Finance departments routinely segment employees by salary band to ensure compensation is aligned with market rates and internal equity policies. A common first step is pulling everyone above a specific threshold — in this case, the six-figure mark — to review total compensation spend at the top of the pay scale. Using the employees table, return name, department, and salary for every employee whose salary is strictly greater than 100,000, ordered by salary descending.

Schema

employees

column	type
id	INTEGER
name	TEXT
department	TEXT
salary	INTEGER

Sample Data

id	name	department	salary
1	Alice	Engineering	120000
2	Bob	Marketing	80000
3	Carol	Engineering	135000
4	Dave	HR	65000
5	Eve	Engineering	100000

Expected Output

name	department	salary
Carol	Engineering	135000
Alice	Engineering	120000

Eve earns exactly 100,000 — not strictly greater — so she is excluded.