Students Who Live in Toronto

List the first_name and last_name of every student whose home city is Toronto. Eight students should come back.

Expected result:

+------------+-----------+
| first_name | last_name |
+------------+-----------+
| Ava        | Patel     |
| Noah       | Kim       |
| Lucas      | Fernandes |
| Mason      | Nguyen    |
| Elijah     | Costa     |
| Emily      | Zhang     |
| Scarlett   | Johnson   |
| Leo        | Martin    |
+------------+-----------+
8 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.