CREATE TABLE staff (address_id VARCHAR2, first_name VARCHAR2)
CREATE TABLE address (address VARCHAR2, address_id VARCHAR2)

Where does the staff member with the first name Elsa live?
SELECT T2.address FROM staff AS T1 JOIN address AS T2 ON T1.address_id = T2.address_id WHERE T1.first_name = 'Elsa'
SELECT "T2"."address" FROM "staff" "T1" JOIN "address" "T2" ON "T1"."address_id" = "T2"."address_id" WHERE "T1"."first_name" = 'Elsa'