Show me the first name of all teachers.
select first_name from teachers
Which city does Lyla live?
select t1.city from addresses as t1 join teachers as t2 on t1.address_id = t2.address_id where t2.first_name = "Lyla"
What about the zip code?
select t1.zip_postcode from addresses as t1 join teachers as t2 on t1.address_id = t2.address_id where t2.first_name = "Lyla"