条件不同时统计数目

DELIMITER $$
CREATE FUNCTION getCount (s VARCHAR(1)) RETURNS INT (6)
BEGIN
    RETURN (
        SELECT
            count(1)
        FROM
            USER u
        WHERE
            u.sex = s
    ) ; END$$
DELIMITER $$

SELECT
    getCount (‘1‘) ‘男生数量‘,
    getCount (‘2‘) ‘女生数量‘,
    getCount (‘1‘) + getCount (‘2‘) ‘总人数‘