SQLize Online / PHPize Online  /  SQLtest Online

drop table if exists employee create table employee ( id smallint, emp_name varchar(255), rating int ) insert into employee values (1,'Vasya',5) insert into employee values (2,'Vasya',3) insert into employee values (3,'Petya',9) insert into employee values (4,'Igor',4) insert into employee values (5,'Nikita',2) ; drop table if exists tasks create table tasks ( id smallint, assignee_id smallint, rating smallint ) insert into tasks values (1,1,5) insert into tasks values (2,1,4) insert into tasks values (3,2,2) insert into tasks values (4,5,5) insert into tasks values (5,5,1) insert into tasks values (6,5,7) insert into tasks values (7,5,9) insert into tasks values (8,5,3) insert into tasks values (9,5,3) insert into tasks values (10,5,5) insert into tasks values (11,2,7) insert into tasks values (12,3,8) insert into tasks values (13,3,8) insert into tasks values (14,2,7) insert into tasks values (15,3,9) insert into tasks values (16,5,4) insert into tasks values (17,1,5) ; select emp_name, count(distinct t2.id) as cnt_tasks from employee t1 left join tasks t2 on t1.id = t2.assignee_id group by emp_name having count(distinct t2.id) < 3 ;