Before budget season kicks off, Microsoft wants a quick look at who's at the top of the pay scale. Pull the top 3 highest-paid employees from the employees table — return their name and salary, ordered by salary descending.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | INTEGER |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 85000 |
| 3 | Carol | Engineering | 135000 |
| 4 | Dave | HR | 72000 |
| 5 | Eve | Engineering | 115000 |
| 6 | Frank | Marketing | 90000 |
| 7 | Grace | HR | 68000 |
| 8 | Heidi | Engineering | 140000 |
| name | salary |
|---|---|
| Heidi | 140000 |
| Carol | 135000 |
| Alice | 120000 |
Heidi, Carol, and Alice have the three highest salaries. Eve (115,000), Frank (90,000), and the remaining employees are excluded by the LIMIT 3.