Select D.manager_id, d.department_name, L.state_province, L.city
FROM Departments D JOIN Locations L
ON D.location_id = L.location_id
where L.city Like 'Oxford';