CREATE TABLE address (address VARCHAR2, address_id VARCHAR2)
CREATE TABLE customer (email VARCHAR2, address_id VARCHAR2, first_name VARCHAR2)

Where does the customer with the first name Linda live? And what is her email?
SELECT T2.address, T1.email FROM customer AS T1 JOIN address AS T2 ON T2.address_id = T1.address_id WHERE T1.first_name = 'LINDA'
SELECT "T2"."address", "T1"."email" FROM "customer" "T1" JOIN "address" "T2" ON "T1"."address_id" = "T2"."address_id" WHERE "T1"."first_name" = 'LINDA'