The Minnesota National Guard and police team were shot in a drive-by shooting