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.
7 lines
375 B
SQL
7 lines
375 B
SQL
/*24. Write a query in SQL to display the full name (first and last name), and salary of those employees who working in any
|
|
department located in London.*/
|
|
SELECT first_name || ' ' || last_name AS Employee_name, salary
|
|
FROM employees
|
|
JOIN departments USING (department_id)
|
|
JOIN locations USING (location_id)
|
|
WHERE city = 'London'; |