w3resource
SQL exercises

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


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: 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?



New Content: Composer: Dependency manager for PHP, R Programming