w3resource

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. From the following tables, write a SQL query to find full name (first and last name), and salary of those employees who work in any department located in 'London' city.

Sample table: departments


Sample table: locations


Sample table: employees


Sample Solution:

SELECT first_name || ' ' || last_name AS Employee_name, salary
	FROM employees 
		JOIN departments USING (department_id) 
		JOIN  locations USING (location_id) 
	WHERE  city = 'London';

Sample Output:

employee_name	salary
Susan Mavris	6500.00

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Display the full name, and salary of those employees who working in any department located in London - Duration

Rows:

Query visualization of Display the full name, and salary of those employees who working in any department located in London - Rows

Cost:

Query visualization of Display the full name, and salary of those employees who working in any department located in London - Cost

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

Previous: From the following tables, write a SQL query to compute the number of days worked by employees in a department of ID 80. Return employee ID, job title, number of days worked.
Next: From the following tables, write a SQL query to find full name (first and last name), job title, starting and ending date of last jobs of employees who worked without a commission percentage.

What is the difficulty level of this exercise?