I'm trying to figure out in my head how to write a query, but I can't seem to think up the logic.
What I want to do is group a days incidents up and count them. then I want to list the data by
Top incidents by day. if that makes sense. example.
Day 1 12/10/2010 - 45 incidents
Day 2 12/11/2010 - 30 incidents
Day 3 12/12/2010- 15 incidents
If anyone knows what this logic would look like I'd appreciate it.
attached is a pic of the table