SQLD(SQL 개발자) 기출 · 집계 함수

이 문제 풀어보기

1. 1.SELECT COL1 AS 컬럼1, AVG(COL2) AS 평균
   FROM TAB1
   GROUP BY COL1
   HAVING AVG(COL2) >= 100;
2. 2.SELECT COL1 AS 컬럼1, AVG(COL2) AS 평균
   FROM TAB1
   WHERE AVG(COL2) >= 100
   GROUP BY 컬럼1;
3. 3.SELECT COL1 컬럼1, AVG(COL2) 평균
   FROM TAB1
   GROUP BY COL2;
4. 4.SELECT COL1 컬럼1, AVG(COL2) 평 균
   FROM TAB1;