What makes sense is to look at where there are fewer or no shootings and see what they might be doing better, then emulate that. We can start with looking across the USA, and then look at the rest of the world.
The researchers identified several factors that were associated with a lower risk of school shootings. They found that the number of school shootings was lower in states that had:
- Mandatory background checks for gun and ammunition purchases.
- Higher spending on mental health.
- Higher spending on K-12 education.
https://www.cbsnews.com/news/school-shootings-states-gun-background-checks-study/
Thirty-nine states had at least one shooting, 34 had less than ten; Florida (14), Georgia (15), North Carolina (12), Tennessee (10), and Texas (14) had the most. A diverse group of states including New York, New Jersey, West Virginia, Wyoming, and seven others didn’t have any… States with higher spending on education and mental health showed lower shooting rates, as did states with stronger background-check gun laws and a greater concentration of people living in urban areas.
https://www.thecut.com/2016/12/what-states-with-the-most-school-shootings-have-in-common.html
Here is a map showing the number of school shootings per state just in 2018:
https://www.wcpo.com/news/national/school-shootings-in-us-when-where-each-shooting-has-occurred-in-2018