SELECT
DATE_FORMAT(tr.updatetime, ‘%Y-%m’), count(1)
FROM
taobao.t_change_record tr
where tr.updatetime>‘1999-01-01’ and tr.updatetime <‘2021-12-01’
GROUP BY DATE_FORMAT(tr.updatetime, ‘%Y-%m’);
SELECT
DATE_FORMAT(tr.updatetime, ‘%Y-%m’), count(1)
FROM
taobao.t_change_record tr
where tr.updatetime>‘1999-01-01’ and tr.updatetime <‘2021-12-01’
GROUP BY DATE_FORMAT(tr.updatetime, ‘%Y-%m’);