WITH t1 AS ( SELECT sId FROM SC WHERE cId IN (1,2,3) GROUP BY sId HAVING (SUM(score) / 3) > 60) SELECT COUNT(*) AS 'count(*)' FROM t1;