SQL Subquery Exercises: Display the department code and name for all departments which located in the city London

SQL SUBQUERY: Exercise-35 with Solution

From the following tables, write a SQL query to find those departments that are located in the city of London. Return department ID, department name.

Sample table: departments

Sample table: locations

Sample Solution:

SELECT department_id, department_name 
  FROM departments 
    WHERE location_id = 
            (
              SELECT location_id 
                FROM locations 
                  WHERE city = 'London'
            );

Sample Output:

department_id	department_name
40		Human Resources

Pictorial Presentation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find those employees who get such a salary, which is the maximum of salaried employee, joining within January 1st, 2002 and December 31st, 2003. Return employee ID, first name, last name, salary, department name and city.
Next: From the following table, write a SQL query to find those employees who earn more than the average salary. Sort the result-set in descending order by salary. Return first name, last name, salary, and department ID.