The attacker has also died from a self-inflicted gunshot wound after opening fire at an ice hockey rink in the US.