SELECT substr(redeem_ts, 1, 10) AS redeem_dt,
       count(1) AS redeem_cnt, sum(face_amt) AS redeem_amt
FROM fact_coupon
WHERE redeem_ts IS NOT NULL
GROUP BY 1;