Instructor Full Names

Return one column called full_name holding each instructor's first and last name joined with a single space (for example Grace Okafor), plus their title. One row per instructor, twelve in all.

Expected result:

+------------------+---------------------+
| full_name        | title               |
+------------------+---------------------+
| Grace Okafor     | Professor           |
| Daniel Reyes     | Assistant Professor |
| Mei Chen         | Associate Professor |
| Samuel Whitaker  | Professor           |
| Priya Natarajan  | Lecturer            |
| Helen Brooks     | Professor           |
| Marcus Lindqvist | Lecturer            |
| Amara Diallo     | Associate Professor |
| Tomasz Nowak     | Assistant Professor |
| Olivia Grant     | Professor           |
+------------------+---------------------+
(showing 10 of 12 rows)

Hints2 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.