【2020090403】if用法

-- 查询男生、女生人数
SELECT 
    SUM(if(ssex='男', 1, 0)) AS '男生人数'
    ,SUM(if(ssex='女', 1,0)) AS '女生人数'    
FROM student;