w3resource
SQL exercises

SQL exercises on employee Database: Find the total annual salary distributed against each job in the year 1991

SQL employee Database: Exercise-92 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

92. Write a query in SQL to find the total annual salary distributed against each job in the year 1991.

Sample table: employees


Sample Solution:

SELECT job_name,
       sum(12*salary)
FROM employees
WHERE to_char(hire_date,'YYYY') = '1991'
GROUP BY job_name;

Sample Output:

 job_name  |   sum
-----------+----------
 CLERK     | 12600.00
 PRESIDENT | 72000.00
 SALESMAN  | 72000.00
 ANALYST   | 37200.00
 MANAGER   | 99084.00
(5 rows)

Practice Online


Sample Database: employee

employee database structure

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

Previous: Write a query in SQL to find the average salary and average total remuneration(salary and commission) for each type of job.
Next: Write a query in SQL to list the employee id, name, department id, location of all the employees.

What is the difficulty level of this exercise?