List records of customers living in city Lockmanfurt.
select * from customers as t1 join addresses as t2 on t1.customer_address_id = t2.address_id where t2.city = "Lockmanfurt";
Just show the first and last name.
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";