Intern — Middle
Departments where more than two employees work
livecode
Task condition
Write an SQL query that outputs the names of departments where the number of employees exceeds two.
CREATE TABLE department
(id int(11), name varchar(100))
;
CREATE TABLE employee
(id int(11), department_id int(11), chief_id int(11), name varchar(100), salary int(11))
;
INSERT INTO department
(id, name)
VALUES
(1, "D1"),
(2, "D2"),
(3, "D3")
;
INSERT INTO employee
(id, department_id, chief_id, name, salary)
VALUES
(1, 1, 5, "John", 100),
(2, 1, 5, "Misha", 600),
(3, 2, 5, "Eugen", 300),
(4, 2, 5, "Tolya", 400),
(5, 1, NULL, "Stepan Chief", 500);