Filter with WHERE + order results.
Return the name and salary of every employee earning more than $150,000. Columns: `name`, `salary`. Order by salary descending. Table: `ci_employees`.
| Column | Type | Key |
|---|---|---|
| id | INT | PK |
| name | TEXT | |
| department_id | INT | FK → ci_departments.id |
| manager_id | INT | FK → ci_employees.id |
| salary | INT | |
| hire_date | DATE |
Each hint you reveal reduces the XP you can earn. Try the query first.
WHERE salary > 150000.
ORDER BY salary DESC.