MySQL 월별 통계 DATE_FORMAT

1. 주별 통계

DATE_FORMAT 함수를 이용한다.

1) ECOLI_DATA 테이블

ID	SIZE_OF_COLONY	DIFFERENTIATION_DATE
1	10	2019/01/01
2	2	2019/05/01
3	100	2020/01/01
4	17	2022/04/01
5	10	2020/09/01
6	101	2021/12/01

2) SQL

SELECT DATE_FORMAT(REG_DT, '%Y-%m') as MONTH
     , COUNT(SIZE_OF_COLONY)        as ECOLI_COUNT
FROM ECOLI_DATA
GROUP BY MONTH

[출처 및 참고]

• https://soobindeveloper8.tistory.com/932