SQL JOINS on HR Database: Display the job title and average salary of employees
SQL JOINS on HR Database: Exercise-19 with Solution
19. Write a query in SQL to display job title and average salary of employees.
Sample table: employees
Sample table: jobs
SELECT job_title, AVG(salary) FROM employees NATURAL JOIN jobs GROUP BY job_title;
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 Purchasing Clerk 2780.0000000000000000 Public Relations Representative 10000.0000000000000000 Purchasing Manager 11000.0000000000000000 Administration Assistant 4400.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
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query in SQL to display department name and the full name (first and last name) of the manager.
Next: Write a query in SQL to display the details of jobs which was done by any of the employees who is presently earning a salary on and above 12000.
What is the difficulty level of this exercise?