需要总计的事件类型

I have a company that has held a certain amount of events that equal 'social'. I need a total of these events based on the COMPANY, but am throwing an error when attempting to SUM or CONVERT or CAST on the EVENT_TYPE column. I've been staring at the issue for too long and thought a fresh set of eyes and brains could help me find the obvious. Here's the Code: I have a company that has held a certain amount