SQLize Online / PHPize Online  /  SQLtest Online

create table sts( id int ); create table sts_value( sts_id int, place int, value int, need_value int ); insert into sts values (1), (2), (3); insert into sts_value values (1, 1, 1, 1), (1, 2, 1, 1), (1, 3, 1, 1), (1, 4, 1, 1), (1, 5, 1, 1), (1, 6, 1, 1), (1, 7, 1, 1), (2, 1, 1, 1), (2, 2, 1, 1), (2, 3, 0, 1), (2, 4, 1, 1), (2, 5, 2, 1), (2, 6, 1, 1), (2, 7, 0, 1), (3, 1, 1, 1), (3, 2, 1, 1), (3, 3, 0, 1), (3, 4, 1, 1), (3, 5, 2, 1), (3, 6, 1, 1), (3, 7, 0, 1); select sts.id, sum(if(sts_value.value = 2, 1, 0)) as sum from sts join sts_value on sts.id = sts_value.sts_id group by sts.id;