SQL：如果列y = z，则计算列x

I'm trying to count customers that are contactable via different channels. The following code will give me a single count of only the customers contactable via SMS. I'm trying to count customers that are contacta