Instructors Paid at Least 90000

Return first_name, last_name and salary for every instructor whose salary is 90000 or more, highest salary first.

Expected result:

+------------+-----------+--------+
| first_name | last_name | salary |
+------------+-----------+--------+
| Olivia     | Grant     | 105000 |
| Samuel     | Whitaker  | 101000 |
| Grace      | Okafor    |  98500 |
| Amara      | Diallo    |  94000 |
| Helen      | Brooks    |  91000 |
+------------+-----------+--------+
5 rows

Hints3 available

Topics:

SELECT Basics

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.