sql = "select count(*),nvl(sum(sessiontime),0),sum(case when mod(sessiontime,60)<>0 then fsip*(sessiontime-mod(sessiontime,60)+60)/6000 else fsip*sessiontime/6000 end) from data_dict_info b,log a where dicttype=101 and b.classid=a.destareacode where callflag=1 and to_char(starttime,'yyyymmdd')>='20050320' and to_char(starttime,'yyyymmdd')<='20050326' order by starttime desc