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

# 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. From the following table, write a SQL query to compute the total annual salary distributed against each job in the year 1991. Return job name, total annual salary.

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

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

What is the difficulty level of this exercise?

﻿