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'
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 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 = value
display the full name ( first and last name ) , and salary of those employees who working in any department located in London .