Show me the first name of all teachers.
select first_name from teachers
Who live in addresses with zip code 918?
select t2.first_name from addresses as t1 join teachers as t2 on t1.address_id = t2.address_id where t1.zip_postcode = "918"
What about their email addresses?
select t2.email_address from addresses as t1 join teachers as t2 on t1.address_id = t2.address_id where t1.zip_postcode = "918"