Common sense tells us that bad guys are ALWAYS going to try to act out their own personal demons by inficting violence on innocent people. They will use the most deadly implement they can find. Guns will ALWAYS be found by bad guys even if guns were completely prohibited by law.
Most mass shooters killed themselves (and stopped killing innocent victims) when confronted by armed good guys.
Armed guards or trained school personnel with guns ARE the answer to reducing school shootings.