display the full name (first and last name), and salary of those employees who working in any department located in London.
CREATE TABLE departments (
    department_id VARCHAR,
    location_id VARCHAR
)

CREATE TABLE locations (
    location_id VARCHAR,
    city VARCHAR
)

CREATE TABLE employees (
    department_id VARCHAR
)
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'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: display the full name (first and last name), and salary of those employees who working in any department located in London. ### Input: CREATE TABLE departments (
    department_id VARCHAR,
    location_id VARCHAR
)

CREATE TABLE locations (
    location_id VARCHAR,
    city VARCHAR
)

CREATE TABLE employees (
    department_id VARCHAR
) ### Response: 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'