I have a SQL query problem and you guys haven't failed me yet, so hopefully, this one will be a piece of cake. I'm trying to write a query to return a category and 2 counts per category based on ...

I need to make a report that I will display in reporting services, but first I thought I should likely just get the query up and running Anyway situation is this:I want to see what the grades were ...