Mysql sum+条件统计各状态数量

SELECT
    source 医疗网站,
    IFNULL( sum( type = 1 ), 0 ) 总数1,
    IFNULL( sum( type = 2 ), 0 ) 总数2,
    IFNULL( sum( type = 3 ), 0 ) 总数3,
    IFNULL( sum( type = 4 ), 0 ) 总数4,
    COUNT( 1 ) 总数 
FROM
    mip_baidu_top 
WHERE
    batch = 4 
GROUP BY
    source 
HAVING
    source != '' 
ORDER BY
    总数 DESC