select fchannel,count(fchannel)fcount from tcustomer_reception
where ftype='½Ó´ý' and siteid=$siteid$ and tagentsid=$tagentsid$ and
convert(varchar(7),fdate,120)>=$fbegmonth$ and convert(varchar(7),fdate,120)<=$fendmonth$
and isnull(fchannel,'')!=''
group by fchannel order by count(fchannel)