Only accumulate the hour. Don't sum the pedestrian count too.
Select second busiest pedestrian hour for each intersection
Sum the pedestrian counts from each record