I'm trying not to reinvent the wheel here. I am assuming that there must already be a query developed to return the number of occurrences within a specified time period. This has got to be an often-used statistical analysis that someone has already developed an SQL query for.

... or am I grasping at straws here?