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
424 B
SQL

/*Write a query in SQL to display the city of the employee whose ID 134 and works there.*/
SELECT city
FROM locations
WHERE location_id =
(SELECT location_id
FROM departments
WHERE department_id =
(SELECT department_id
FROM employees
WHERE employee_id=134));