Employees Earning Over 100K - Easy SQL Filtering Interview Problem

Problem

Google's finance team wants to know who in the company, and in which department, is earning over six figures. 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

Explanation

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

Hints