getting this error
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '>'.
when using this syntax
IIF(sum(calls)>0,(SUM(cost)/SUM(calls)),0) as 'CPC'
where (REportDate between '3/14/11' and '3/20/11')and sitename = 'Google'--where (REportDate between @start and @end)and sitename = 'Google'
group by sitename,campaign