﻿ SQL exercises on employee Database: List the department where at least two employees are working - w3resource

# SQL exercises on employee Database: List the department where at least two employees are working

## SQL employee Database: Exercise-98 with Solution

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

98. From the following table, write a SQL query to find those departments where at least two 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(*) >= 2;
``````

Sample Output:

``` dep_id | count
--------+-------
3001 |     6
1001 |     3
2001 |     5
(3 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?

Test your Programming skills with w3resource's quiz.

﻿

## SQL: Tips of the Day

How to restore a dump file from mysqldump?

It should be as simple as running this:

```mysql -u <user> -p < db_backup.dump
```

If the dump is of a single database you may have to add a line at the top of the file:

```USE <database-name-here>;
```

Ref: https://bit.ly/3xKmyw2