CREATE TABLE departments (department_id VARCHAR2, location_id VARCHAR2)
CREATE TABLE locations (location_id VARCHAR2, city VARCHAR2)
CREATE TABLE employees (department_id VARCHAR2)

display the full name (first and last name), and salary of those employees who working in any department located in London.
SELECT first_name, last_name, salary 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'
SELECT "first_name", "last_name", "salary" FROM "employees" "T1" JOIN "departments" "T2" ON "T1"."department_id" = "T2"."department_id" JOIN "locations" "T3" ON "T2"."location_id" = "T3"."location_id" AND "T3"."city" = 'London'