President calls shooting 'horrific and tragic'