mysql 按月/分组查询 季度，年份组合查询

SELECT
    MONTH (create_time) AS months,
    COUNT(*) AS num
FROM
    gc_overseas_chinese
WHERE
    YEAR (create_time) = 2020
AND QUARTER (create_time) = 2
AND date_format(create_time, '%y%m%d') >= date_format('2020-01-01', '%y%m%d')
AND date_format(create_time, '%y%m%d') <= date_format('2020-07-20', '%y%m%d')
GROUP BY
    MONTH (create_time)