Instructors Teaching a 300-Level Course

List the instructors who teach at least one third-year course (level = 300). Return first_name and last_name, sorted by last_name. An instructor teaching two such courses appears once. BUS320 is a 300-level course with no instructor; it must not break the query.

Expected result:

+------------+-----------+
| first_name | last_name |
+------------+-----------+
| Tomasz     | Nowak     |
| Grace      | Okafor    |
| Daniel     | Reyes     |
+------------+-----------+
3 rows

Hints3 available

Topics:

Subqueries

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.