使用sql的CASE语句

SELECT  ds AS 日期
        ,operate as 充值类型
        ,SUM(num) AS 总的
        ,sum(CASE  operate WHEN '22' THEN  num ELSE 0 END) 类型1
        ,sum(CASE  operate WHEN '12' THEN  num ELSE 0 END) 类型2
        ,sum(CASE  operate WHEN '15' THEN  num ELSE 0 END) 类型3
        ,sum(CASE  WHEN operate = '3'or operate = '4'or operate = '5' or operate = '6' or operate = '7' 
        or operate = '8' or operate = '10'or operate ='11' or operate ='12' 
        or operate ='13' or operate = '20'THEN  num ELSE 0 END) 类型4   
        ,
FROM    record
GROUP BY ds ,operate
;