Um, actually you may have heard of the Sandy Hook school shooting, which happens to be the deadliest in US history to date. It's in Newtown Connecticut which borders New York state. Granted there are certainly more in the south, which is not surprising given that the strong right leaning people who live there seem to cherish their 2nd amendment more than life itself. My point though was that adding more guns to schools wherever they may be isn't a very smart solution to the problem IMO.
There have been 16 school spree shootings in Texas. The same in Georgia. And I think it's 17 in Florida.
There have been none in New York or New Jersey.
I might point out that Texas, Georgia and Florida have some of the weakest gun laws in America while New York and New Jersey and, since Sandy Hook, when they brought in sweeping new gun control legislation, Connecticut, have some of the strongest gun control laws in America.