CREATE TABLE Teachers (address_id VARCHAR2, first_name VARCHAR2)
CREATE TABLE Addresses (zip_postcode VARCHAR2, address_id VARCHAR2)

What is the zip code of the address where the teacher with first name 'Lyla' lives?
SELECT T1.zip_postcode FROM Addresses AS T1 JOIN Teachers AS T2 ON T1.address_id = T2.address_id WHERE T2.first_name = "Lyla"
SELECT "T1"."zip_postcode" FROM "Addresses" "T1" JOIN "Teachers" "T2" ON "Lyla" = "T2"."first_name" AND "T1"."address_id" = "T2"."address_id"