求助分组统计问题，现在我统计出了bingqu的值，但后面还有统计QaId的总和，QaId为空的和不为空的组合

[菜鸟111号]

select bingqu ,count(bingqu) as countnum from (
select SerialId,PatientId,patientType,name as WardOfficesId,
WardDoctorId,name as ExecuteOfficesId,PatientName,PatientGender,
PatientAge,PhoneNumber,PatientAdress,ChargeableTime,PatientStatus,

QaId,SubmitTime,IpAdress,BingQu,ChuangHao,ZhengDuan
from Tb_Evaluate
left join Tb_Departments on Tb_Evaluate.ExecuteOfficesId = Tb_Departments.id
and Tb_Evaluate.WardOfficesId = Tb_Departments.id
where patientType = 'Y'
) as a group by bingqu ,qaid

[二月十六]

问题是什么？

[菜鸟111号]

引用 1 楼 sinat_28984567 的回复:

问题是什么？

现在我统计出了bingqu的值，但后面还有统计QaId的总和，QaId为空的和不为空的组合

[二月十六]

SELECT
    bingqu,
    COUNT(bingqu) AS countnum,
	SUM(CASE WHEN QaId IS NOT NULL THEN 1 ELSE 0 END)QaId,
	SUM(CASE WHEN QaId IS NULL THEN 1 ELSE 0 END)NullQaId
FROM
    (
        SELECT
            SerialId,
            PatientId,
            patientType,
            name          AS WardOfficesId,
            WardDoctorId,
            name          AS ExecuteOfficesId,
            PatientName,
            PatientGender,
            PatientAge,
            PhoneNumber,
            PatientAdress,
            ChargeableTime,
            PatientStatus,
            QaId,
            SubmitTime,
            IpAdress,
            BingQu,
            ChuangHao,
            ZhengDuan
        FROM
            Tb_Evaluate
            LEFT JOIN
                Tb_Departments
                    ON Tb_Evaluate.ExecuteOfficesId = Tb_Departments.id
                       AND Tb_Evaluate.WardOfficesId = Tb_Departments.id
        WHERE
            patientType = 'Y'
    ) AS a
GROUP BY
    bingqu

[菜鸟111号]

引用 3 楼 sinat_28984567 的回复:

SELECT
    bingqu,
    COUNT(bingqu) AS countnum,
	SUM(CASE WHEN QaId IS NOT NULL THEN 1 ELSE 0 END)QaId,
	SUM(CASE WHEN QaId IS NULL THEN 1 ELSE 0 END)NullQaId
FROM
    (
        SELECT
            SerialId,
            PatientId,
            patientType,
            name          AS WardOfficesId,
            WardDoctorId,
            name          AS ExecuteOfficesId,
            PatientName,
            PatientGender,
            PatientAge,
            PhoneNumber,
            PatientAdress,
            ChargeableTime,
            PatientStatus,
            QaId,
            SubmitTime,
            IpAdress,
            BingQu,
            ChuangHao,
            ZhengDuan
        FROM
            Tb_Evaluate
            LEFT JOIN
                Tb_Departments
                    ON Tb_Evaluate.ExecuteOfficesId = Tb_Departments.id
                       AND Tb_Evaluate.WardOfficesId = Tb_Departments.id
        WHERE
            patientType = 'Y'
    ) AS a
GROUP BY
    bingqu

厉害了， 我怎么没想到用sum,

[二月十六]

引用 4 楼 qq_28419365 的回复:

[quote=引用 3 楼 sinat_28984567 的回复:]

SELECT
    bingqu,
    COUNT(bingqu) AS countnum,
	SUM(CASE WHEN QaId IS NOT NULL THEN 1 ELSE 0 END)QaId,
	SUM(CASE WHEN QaId IS NULL THEN 1 ELSE 0 END)NullQaId
FROM
    (
        SELECT
            SerialId,
            PatientId,
            patientType,
            name          AS WardOfficesId,
            WardDoctorId,
            name          AS ExecuteOfficesId,
            PatientName,
            PatientGender,
            PatientAge,
            PhoneNumber,
            PatientAdress,
            ChargeableTime,
            PatientStatus,
            QaId,
            SubmitTime,
            IpAdress,
            BingQu,
            ChuangHao,
            ZhengDuan
        FROM
            Tb_Evaluate
            LEFT JOIN
                Tb_Departments
                    ON Tb_Evaluate.ExecuteOfficesId = Tb_Departments.id
                       AND Tb_Evaluate.WardOfficesId = Tb_Departments.id
        WHERE
            patientType = 'Y'
    ) AS a
GROUP BY
    bingqu

厉害了， 我怎么没想到用sum,[/quote]
如果没问题了就结贴结贴

[菜鸟111号]

引用 5 楼 sinat_28984567 的回复:

[quote=引用 4 楼 qq_28419365 的回复:]
[quote=引用 3 楼 sinat_28984567 的回复:]

SELECT
    bingqu,
    COUNT(bingqu) AS countnum,
	SUM(CASE WHEN QaId IS NOT NULL THEN 1 ELSE 0 END)QaId,
	SUM(CASE WHEN QaId IS NULL THEN 1 ELSE 0 END)NullQaId
FROM
    (
        SELECT
            SerialId,
            PatientId,
            patientType,
            name          AS WardOfficesId,
            WardDoctorId,
            name          AS ExecuteOfficesId,
            PatientName,
            PatientGender,
            PatientAge,
            PhoneNumber,
            PatientAdress,
            ChargeableTime,
            PatientStatus,
            QaId,
            SubmitTime,
            IpAdress,
            BingQu,
            ChuangHao,
            ZhengDuan
        FROM
            Tb_Evaluate
            LEFT JOIN
                Tb_Departments
                    ON Tb_Evaluate.ExecuteOfficesId = Tb_Departments.id
                       AND Tb_Evaluate.WardOfficesId = Tb_Departments.id
        WHERE
            patientType = 'Y'
    ) AS a
GROUP BY
    bingqu

厉害了， 我怎么没想到用sum,[/quote]
如果没问题了就结贴结贴[/quote]
好咧，非常感谢！