If Local Schools Approve, Should Off-Duty & Retired Cops be Allowed to Carry Concealed Firearms in School Zones as Security?

The only mass shooting on campus in the last decade have been in gun free zones. It's advertising a bunch of people won't be able to defend themselves.