22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM( CASE WHEN CONVERT(VARCHAR(8), xf_rq, 8)
BETWEEN '07:00:00' AND '08:00:00' THEN 1
ELSE 0
END
) AS 早餐第一次消费次数
, SUM( CASE WHEN CONVERT(VARCHAR(8), xf_rq, 8)
BETWEEN '07:00:00' AND '08:00:00' THEN xf_jr
ELSE 0
END
) AS 早餐第一次消费金额
, SUM( CASE WHEN CONVERT(VARCHAR(8), xf_rq, 8)
BETWEEN '11:00:00' AND '12:00:00' THEN 1
ELSE 0
END
) AS 午餐第一次消费次数
, SUM( CASE WHEN CONVERT(VARCHAR(8), xf_rq, 8)
BETWEEN '11:00:00' AND '12:00:00' THEN xf_jr
ELSE 0
END
) AS 午餐第一次消费金额
, SUM(xf_jr) AS 早餐和午餐合计金额
FROM #Xfs AS a
WHERE xf_rq BETWEEN '2018-01-01 00:00:00' AND '2018-01-30 23:59:59'
AND (CONVERT(VARCHAR(8), xf_rq, 8) BETWEEN '07:00:00' AND '08:00:00' OR CONVERT(VARCHAR(8), xf_rq, 8) BETWEEN '11:00:00' AND '12:00:00');