Sobes.tech
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);