sql 统计

select count(id) ,sum(cast(TK3_13 as decimal(10,2)))/10000 as zmj,
avg(cast(cast(zfj as float)/TK3_13 as decimal(10,2))) as aaa from table
where substring(date,0,8)='2010-10'