select fsaleevent,count(fsaleevent)fcount,SUM(forderamount)forderamount 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 fsaleevent is not null
group by fsaleevent