[G_SQL] p95 : 그룹함수의 추가기능 Having 절

SELECT student, count(*) * 450.00 as tuition_costs
FROM enrolls
WHERE grade = 2
group by student;

select student, avg(grade), count(*) as courses
FROM enrolls
GROUP BY student
HAVING AVG(grade) > 2.50;

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

SELECT section, AVG(grade), count(*) as students
FROM enrolls
GROUP BY section
HAVING count(*) > 4;