mysql - 我的 sql 对计数值求和

Question

Select Count(Case When an_user_plan.campaign_pid != 0 Then 1 End) As Email,
  Count(Case When an_user_plan.sms_pid != 0 Then 1 End) As Sms,
  Count(Case When an_user_plan.survey_pid != 0 Then 1 End) As Survey,
  sum(Email,Sms,Survey)as total
From an_user_plan 

此 sum(Email,Sms,Survey)as Total 在如何对三个值求和方面存在错误我想要总计为三个计数值的加法怎么办请帮帮我

Answer 1

SELECT SUM(campaign_pid != 0 +
           sms_pid != 0 +
           survey_pid != 0) AS total, ...