SELECT TO_CHAR(TO_DATE(SUBSTR(T.CREATE_TIME, 1, 8),'YYYYMMDD'),'YYYY-MM-DD') 日期,
DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap') 站点,
count(DISTINCT ORDER_NO),
SUM(T.ORDER_MONEY)
FROM T
LEFT T1
ON T.PACKAGE_NO = T1.PACKAGE_NO
WHERE T.CREATE_TIME >= '20160502'
AND T.CREATE_TIME < '20160509'
AND T.ORDER_STAT IN ('020', '050')
GROUP BY TO_CHAR(TO_DATE(SUBSTR(T.CREATE_TIME, 1, 8),'YYYYMMDD'),'YYYY-MM-DD'),
DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap')
DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap') 站点,
count(DISTINCT ORDER_NO),
SUM(T.ORDER_MONEY)
FROM T
LEFT T1
ON T.PACKAGE_NO = T1.PACKAGE_NO
WHERE T.CREATE_TIME >= '20160502'
AND T.CREATE_TIME < '20160509'
AND T.ORDER_STAT IN ('020', '050')
GROUP BY TO_CHAR(TO_DATE(SUBSTR(T.CREATE_TIME, 1, 8),'YYYYMMDD'),'YYYY-MM-DD'),
DECODE(T.USER_SOURCE, '010', 'pc', '020','app','030','wap')