From the following tables, write a SQL query to find those employees whose department is located in the city 'London'. Return first name, last name, salary, and department ID
- برمجة سي كيو ال sql
- 2021-09-02
- mhanasmh00489829403
الأجوبة
SELECT first_name, last_name, salary, department_id
FROM employees
WHERE department_id IN
(SELECT department_id
FROM departments
WHERE location_id =
(SELECT location_id
FROM locations
WHERE city = 'London'));Sample Output:
first_name last_name salary department_id Susan Mavris 6500.00 40
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال