On that note:
I don't see why schools are against a police officer in schools. It's better than security cameras. You still have to watch the cameras which is only a preventative measure rather than an active one. Someone still has to be paid. This wouldn't solve issues like the elementary shooting.
In bigger cities, they always have security guards hanging around in the hallways, and they have a police station near every university college. They can't not have this, it's too much of a security risk, and even having these police officers or security guards is a deterrent in practice. Check rates of every large college and see how many crimes of those are gun related (hint: almost none, they're very rare. The highest are alcohol, drugs, and assault/battery)
Anecdotal, I feel safer knowing that someone's there simply to protect me.
Aren't you now arguing in favor of the government protecting us from guns, which are intended to protect us from the government?