﻿ SQL exercises on employee Database: Display the department name, grade, no. of employees where at least two employees are working as a SALESMAN - w3resource

# SQL exercises on employee Database: Display the department name, grade, no. of employees where at least two employees are working as a SALESMAN

## SQL employee Database: Exercise-100 with Solution

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

100. From the following table, write a SQL query to find those departments where at least two employees work as a SALESMAN in each grade. Return department name, grade and number of employees.

Sample table: employees

Sample table: department

Sample Solution:

``````SELECT d.dep_name,
count(*)
FROM employees e,
department d,
WHERE e.dep_id = d.dep_id
AND e.job_name = 'SALESMAN'
AND e.salary BETWEEN s.min_sal AND s.max_sal
GROUP BY d.dep_name,
HAVING count(*) >= 2;
``````

Sample Output:

``` dep_name  | grade | count
-----------+-------+-------
MARKETING |     2 |     2
MARKETING |     3 |     2
(2 rows)
```

Relational Algebra Expression:

Relational Algebra Tree:

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

﻿