Can you show me the first and last names of all employees who work in any department located in London please?
SELECT first_name ,  last_name  FROM employees AS T1 JOIN departments AS T2 ON T1.department_id   =   T2.department_id JOIN  locations AS T3 ON T2.location_id   =   T3.location_id WHERE  T3.city   =   'London'
employees who work in any department located in London refers to joining employees, departments, and locations tables on matching department_id and location_id where city = 'London'; first and last names of all employees refers to selecting first_name, last_name from the result of the join.