Yeah, sadly we already know the solution, ban or heavily restrict guns.

Every place with more guns has more shootings. It is so simple it seems almost tautological. Yet somehow this very simple fact is controversial.