1-- 부서별 직원 수
2SELECT department, COUNT(*) AS 직원수
3FROM employees
4GROUP BY department;
5
6-- 결과:
7-- department | 직원수
8-- 개발팀     | 15
9-- 디자인팀   | 8
10-- 마케팅팀   | 12
11
12-- 부서별 평균 급여
13SELECT department, AVG(salary) AS 평균급여
14FROM employees
15GROUP BY department
16ORDER BY 평균급여 DESC;