What are full names and salaries of employees working in the city of 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'
employees working in the city of London refers to filtering by city = 'London'; full names refer to concatenation or selection of first_name and last_name; salaries refer to selection of salary; employees, departments, and locations data are joined based on department_id and location_id to filter employees by city.