The other day at work there was a need for a report that our reporting system was having trouble putting out. So the fix was to write it ourselves. It's not too complex and for some it may be quite elementary, but here it is none-the-less.
Being that I work for a school district there was a need for a report by campus and grade level of the number of students that fell into a certain category. So for the sake of this report we want a count of all active students based on their campus and their grade level.
Below is the stripped down version of how this was accomplished.
WHERE studentStatus = 'A'
GROUP BY Campus, Grade
ORDER BY Campus
Hopefully this helps!