You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

11 lines
396 B

/*Write a query in SQL to display the department code and name for all departments which located in the city London.
SELECT department_id, department_name
FROM departments
WHERE location_id =
SELECT location_id
FROM locations
WHERE city = 'London'