select count(1),
       to_char(r.datelastmaint, ‘yyyy-mm-dd hh24:mi‘),
       sum(abs(r.tranamt))
  from deprtxn r
 group by to_char(r.datelastmaint, ‘yyyy-mm-dd hh24:mi‘);