select fappname, sum(ftimes) as ftimes
from tapprequest
where siteid =$siteid$
  and convert (varchar (10), fdate, 120)>=$fbegdate$ and convert (varchar (10), fdate, 120)<=$fenddate$
group by fappname