What are the email addresses of teachers whose address has zip code "918"?
create table addresses (address_id varchar, zip_postcode varchar, PRIMARY KEY (address_id)); create table teachers (email_address varchar, address_id varchar, PRIMARY KEY (email_address))
select t2.email_address from addresses as t1 join teachers as t2 on t1.address_id = t2.address_id where t1.zip_postcode = "918"