We have a table includes the payroll of employees consist of 2 fields:
Field 2: Amount
The query must create a list includes all employees live in London.
This is the statement
Select EmployeeId, Amount from EmployeesPayroll
where EmployeeId in (SELECT Employeeid FROM Employees Where City=’London’)