| 123456789101112131415 |
- SELECT
- SUM(E.提现金额) AS 提现金额,
- SUM(E.手续费) AS 手续费,
- SUM(E.实际到账金额) AS 实际到账金额
- FROM(
- SELECT
- A.USER_NAME AS 会员编号,
- W.AMOUNT AS 提现金额,
- W.FEES AS 手续费,
- W.REAL_AMOUNT AS 实际到账金额,
- W.AUDIT_STATUS AS 提现状态,
- FROM_UNIXTIME(W.AUDITED_AT,'%Y-%m-%d %H:%i:%S') AS 审核时间
- FROM AR_WITHDRAW W LEFT JOIN AR_USER A ON W.USER_ID = A.ID ) E
- WHERE E.提现状态 = 2 AND E.审核时间 >= '2021-09-01 00:00:00' AND E.审核时间 < '2021-10-01 00:00:00'
-
|
