Please help with the below SQL to get the counts: as counts in groups of 4. It is giving error of "expression containing an aggregate or a subquery". How can I get the counts?

I believe, you have posted only half of your code over here...

can you please give us the full details...

like the DDL for the tables involved in the select statement and then the complete Select statement for our analysis and proper reponse, or else many of us may not be able to help you... unless some geek who can look into your brain and get the remaning code...

---

Nothing is Permanent... even Knowledge.... My Blog