sql统计一个字段各个值各有多个个的方法

SELECT COUNT(CASE WHEN apprStatus = 1 and policy_id IN('19657ffd7b6o25bj6ojr') THEN 1 END) AS count_init, COUNT(CASE WHEN apprStatus = 2 and policy_id IN('19657ffd7b6o25bj6ojr') THEN 1 END) AS count_appl, COUNT(CASE WHEN apprStatus = 3 and policy_id IN('19657ffd7b6o25bj6ojr') THEN 1 END) AS count_appr, COUNT(CASE WHEN policy_id IN('19657ffd7b6o25bj6ojr') THEN 1 END) AS count_count_tota, COUNT(CASE WHEN apprStatus = 4 and policy_id IN('19657ffd7b6o25bj6ojr') THEN 1 END) AS count_reje FROM scan_result;