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
转载于:https://www.cnblogs.com/mfser/p/11304378.html