56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
mo.user_id as userId,
IFNULL(SUM(IF(mo.msg_status = 0,mo.real_money,0)),0) AS totalSum
FROM
msg_order mo
WHERE mo.msg_status is not null
AND QUARTER(mo.send_time)=QUARTER(DATE_SUB(now(),INTERVAL 1 QUARTER))
GROUP BY userId