Consider the below query and choose the correct answer

select c$.$ Name as Category, count$($p$.$ProductID$)$ as NoOfProducts

from Production.Product as p$,$ Production.ProductSubcategory as s$,$ Production.Prod

uctCategory as c

where p$.$ProductSubcategoryID $=$ s$.$ProductSubcategoryID

and s$.$ProductCategoryID $=$ c$.$ProductCategoryID

group by s$.$ Name;

The query is syntactically correct but gives the wrong answer

The query is syntactically wrong

The query is syntactically correct and gives the correct answer

The query contains one or more wrongly named clauses