Any way I can do this? Should I do this?

[Bob Barrows]

GOT IT!! All is well. Changed COUNT(*) to COUNT(l.Cat_Id). Thanks
Bob for your input, help guidance, and for all around being a nice
guy!

Glad to hear it!

I hope you now see the point of creating a tabular representaion of your
desired results. Not only does it help convey the requirements to somebody
else, it also may help you solve the problem yourself by forcing you to see
the output the way the query engine would.