CREATE TABLE Addresses (address_id VARCHAR, zip_postcode VARCHAR)
CREATE TABLE Teachers (email_address VARCHAR, address_id VARCHAR)

What are the email addresses of teachers whose address has zip code '918'?
SELECT T2.email_address FROM Addresses AS T1 JOIN Teachers AS T2 ON T1.address_id = T2.address_id WHERE T1.zip_postcode = "918"
SELECT "T2"."email_address" FROM "Addresses" AS "T1" JOIN "Teachers" AS "T2" ON "T1"."address_id" = "T2"."address_id" WHERE "918" = "T1"."zip_postcode"