SELECT FROM_UNIXTIME(add_time, ‘%Y-%m-%d‘) AS date, sum(price), user_idFROM `ryc_order_course`WHERE add_time != ‘‘GROUP BY date, user_id
根据时间戳 统计每天用户的金额总数
原文:https://www.cnblogs.com/guolc/p/9934557.html