An overwhelming majority of school shootings are carried out by somebody with a connection to the school. It's pretty rare that it's somebody saying "I feel like shooting a bunch of people, that random school looks nice and vulnerable."
Another good point. The motivation is not "that looks like an easy place to shoot up". It's typically someone with some personal connection to the place.