Operator fault in query

SELECT siteapplications.Application, Count(visits.VisitId) AS CountOfVisitId
FROM visits, siteapplications
WHERE visits.SiteApplicationId=siteapplications.ApplicationID and Month([visits.VisitTime)]=month and Year([visits.VisitTime])=year
GROUP BY siteapplication开发者_JS百科s.Application
ORDER BY CountOfVisitId DESC;

I get a operator fault and when I click ok Group by is highlighted??

Can anyone help, thx all

and Month([visits.VisitTime)]

Your paren closing is off