﻿ SQL JOINS on HR: Display the job title and average salary of employees - w3resource

# SQL JOINS on HR Database: Display the job title and average salary of employees

## SQL JOINS on HR Database: Exercise-19 with Solution

19. From the following table, write a SQL query to compute the average salary of employees for each job title.

Sample table: jobs

Sample Solution:

``````SELECT job_title, AVG(salary)
FROM employees
NATURAL JOIN jobs
GROUP BY job_title;
``````

Sample Output:

```job_title			avg
Marketing Manager		13000.0000000000000000
Marketing Representative	6000.0000000000000000
Finance Manager			12000.0000000000000000
Shipping Clerk			3215.0000000000000000
Public Accountant		8300.0000000000000000
Administration Vice President	17000.000000000000
Programmer			5760.0000000000000000
Accountant			7920.0000000000000000
Public Relations Representative	10000.0000000000000000
Sales Manager			12200.000000000000
Sales Representative		8350.0000000000000000
President			24000.000000000000
Stock Manager			7280.0000000000000000
Human Resources Representative	6500.0000000000000000
Accounting Manager		12000.0000000000000000
Stock Clerk			2785.0000000000000000
```

Relational Algebra Expression:

Relational Algebra Tree:

Pictorial Presentation:

## Query Visualization:

Duration:

Rows:

Cost:

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

What is the difficulty level of this exercise?

﻿