count函数的分条件统计

SELECT
COUNT(b.com_sts) AS countall,
COUNT(
CASE
WHEN b.com_sts = '0' THEN
b.com_sts
END
) countsts,
COUNT(
CASE
WHEN b.com_sts = '1' THEN
b.com_sts
END
) AS countout,
(
SELECT
count(1)
FROM
(
SELECT
bci.id,
bci.fault_sts,
bci.com_sts,
bci.province,
bci.leave_no,
bce.longitude,
bce.latitude
FROM
bz_car_info bci,
bz_car_extend_info bce
WHERE
bci.id = bce.car_id
UNION
SELECT
bci.id,
bci.fault_sts,
bci.com_sts,
bci.province,
bci.leave_no,
bceh.longitude,
bceh.latitude
FROM
bz_car_info bci,
bz_car_extend_info_hp bceh
WHERE
bci.id = bceh.car_id
) a
WHERE
a.fault_sts = '1'
AND a.com_sts = '0'
) AS countfault
FROM
(
SELECT
bci.id,
bci.fault_sts,
bci.com_sts,
bci.province,
bci.leave_no,
bce.longitude,
bce.latitude
FROM
bz_car_info bci,
bz_car_extend_info bce
WHERE
bci.id = bce.car_id
UNION
SELECT
bci.id,
bci.fault_sts,
bci.com_sts,
bci.province,
bci.leave_no,
bceh.longitude,
bceh.latitude
FROM
bz_car_info bci,
bz_car_extend_info_hp bceh
WHERE
bci.id = bceh.car_id
) b