SQL语句求指点！！

--试下
select to_char(t2.start_time, 'yyyy-MM-dd'),
       count(*),
       sum(t2.amount) / 100,
count(decode(t2.rsp_code,'00',1,null)) sussess
  from trans_log t2, vip_log t3
where t3.merch_phone = t2.phone_no
   and t3.term_trc = t2.term_trc
group by to_char(t2.start_time, 'yyyy-MM-dd');