Oracle one SQL statement statistics top-up list today, yesterday, three days before the day before the recharge record

Select NVL (SUM (case create_date_time>=to_date (' 2014-11-24 00:00:00 ', ' yyyy-mm-dd hh24:mi:ss ') and Create_date_ Time<=to_date (' 2014-11-24 23:59:59 ', ' yyyy-mm-dd hh24:mi:ss ') then amount end), 0) TODAY,NVL (sum (case when Create_ Date_time>=to_date (' 2014-11-23 00:00:00 ', ' yyyy-mm-dd hh24:mi:ss ') and Create_date_time<=to_date (' 2014-11-23 23:59:59 ', ' yyyy-mm-dd hh24:mi:ss ') then amount end), 0) yesterday

and Create_date_time<=to_date (' 2014-11-22 23:59:59 ', ' yyyy-mm-dd hh24:mi:ss ') then amount end), 0) Thedaybeforeyesterday
From T_pay;

Suppose today is 2014-11-24

Oracle one SQL statement statistics top-up list today, yesterday, three days before the day before the recharge record