Andrew's final video uploaded minutes before the shooting