SQL JOINS on HR Database: Display the full name, and salary of those employees who working in any department located in London
SQL JOINS on HR Database: Exercise-24 with Solution
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.
Sample table: departments
Sample table: locations
Sample table: employees
SELECT first_name || ' ' || last_name AS Employee_name, salary FROM employees JOIN departments USING (department_id) JOIN locations USING (location_id) WHERE city = 'London';
employee_name salary Susan Mavris 6500.00
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query in SQL to display the employee ID, job name, number of days worked in for all those jobs in department 80.
Next: Write a query in SQL to display full name(first and last name), job title, starting and ending date of last jobs for those employees with worked without a commission percentage.
What is the difficulty level of this exercise?