81,122
社区成员




SELECT date_format(create_time, '%Y-%m'), count(fee)
FROM t_sales
GROUP BY date_format(create_time, '%Y-%m')
ORDER BY date_format(create_time, '%Y-%m');
SELECT date_format(create_time, '%Y-%m'), sum(fee)
FROM t_sales
GROUP BY create_format(mt_time, '%Y-%m')
ORDER BY create_format(mt_time, '%Y-%m');