mysql--统计每月的交易金额和交易笔数

SELECT
DATE_FORMAT(t.payDateTime, “%Y-%m”) month,
COUNT(1) num,
IFNULL(SUM(payMoney), 0) sumAmount
FROM
trade t


t.payDateTime >= #{beginTime}
AND t.payDateTime < #{endTime}


AND tradeType = #{tradeType}


GROUP BY DATE_FORMAT(t.payDateTime, “%Y-%m”);