It’s a little less than once per week, on average. School shootings are much more rare. Wikipedia has the list, but it makes me too depressed to go through and tally it up to get the average.

Considering there are tens of thousands of schools across the US, most cops will never have to deal with a mass shooting, much less a school shooting.