CREATE TABLE Customers (first_name VARCHAR, last_name VARCHAR, customer_address_id VARCHAR)
CREATE TABLE Addresses (address_id VARCHAR, city VARCHAR)

List first name and last name of customers lived in city Lockmanfurt.
SELECT T1.first_name, T1.last_name FROM Customers AS T1 JOIN Addresses AS T2 ON T1.customer_address_id = T2.address_id WHERE T2.city = "Lockmanfurt"
SELECT "T1"."first_name", "T1"."last_name" FROM "Customers" AS "T1" JOIN "Addresses" AS "T2" ON "Lockmanfurt" = "T2"."city" AND "T1"."customer_address_id" = "T2"."address_id"