sql---整点查询的sql

SELECT
  SUM(total_amount) AS order_total,
  (SUM(total_amount)*0.02) AS order_profits,
  (SELECT
     IFNULL(SUM(money),0) AS totalRefundMoney
   FROM live_pay.pay_capital_out
   WHERE business_type = 'TICKET'
       AND STATUS = '2'
       AND create_time > TIMESTAMP(ADDDATE(DATE(SYSDATE()), - 1))
       AND create_time < TIMESTAMP(DATE(SYSDATE()))) AS order_refund
FROM p_order_detail_info
WHERE order_status = '4'
    AND pay_status = '2'
    AND create_time > TIMESTAMP(ADDDATE(DATE(SYSDATE()), - 1))
    AND create_time < TIMESTAMP(DATE(SYSDATE()))