mysql按时间月份查询数据

SELECT 
    DATE_FORMAT(call_begin_time, '%Y-%m'), count(1)
FROM
    qy_riskcontrol_prod.phone_statements
WHERE
    phone_id = 1
GROUP BY DATE_FORMAT(call_begin_time, '%Y-%m');

引用
https://www.cnblogs.com/qlqwjy/p/7718219.html