﻿ SQL exercises on employee Database: List the no. of employees in each department where the no. is less than 4 - w3resource

# SQL exercises on employee Database: List the no. of employees in each department where the no. is less than 4

## SQL employee Database: Exercise-101 with Solution

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

101. From the following tables, write a SQL query to find those departments where less than four employees work. Return department ID, number of employees.

Sample table: employees

Sample Solution:

``````SELECT dep_id,
count(*)
FROM employees
GROUP BY dep_id
HAVING count(*)<4;
``````

Sample Output:

``` dep_id | count
--------+-------
1001 |     3
(1 row)
```

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?

Test your Programming skills with w3resource's quiz.

﻿