Mamdani blasted the shooting, which took place on a residential street as New Yorkers were coming home from work and children were walking back from school