SQLize Online / PHPize Online  /  SQLtest Online

create table department ( id integer not null unique, department_name varchar not null, is_active bool not null ); create table person ( id integer not null, name varchar not null, salary integer not null, department_id integer not null, constraint fk_department_id_department foreign key (department_id) references department (id) ); insert into department (id, department_name, is_active) values (1, 'Admin', true), (2, 'IT', true), (3, 'Production', false); insert into person (id, name, salary, department_id) values (1, 'Serg', 1754, 2), (2, 'Sem', 123311, 1), (3, 'Vova', 321311, 1), (4, 'Sveta', 11233, 2), (5, 'Lena', 5232, 3), (6, 'Dima', 55555, 3); select d.department_name, COUNT(p.id) as Количество_Работников from department d join person p on d.id = p.department_id Group by d.department_name;