使用mysql进行分组查询

1、使用groupby

SELECT project_status, COUNT(*) AS count
FROM pro_project
where status = 1
GROUP BY project_status;

2.使用when then

SELECT
    COUNT(*) AS allProjectNum,
    SUM(CASE WHEN project_status = 1 THEN 1 ELSE 0 END) AS openProjectNum,
    SUM(CASE WHEN project_status = 2 THEN 1 ELSE 0 END) AS businessProjectNum,
    SUM(CASE WHEN project_status = 3 THEN 1 ELSE 0 END) AS preparationProjectNum,
    SUM(CASE WHEN project_status = 4 THEN 1 ELSE 0 END) AS batchProductionProjectNum,
    SUM(CASE WHEN project_status = 5 THEN 1 ELSE 0 END) AS settlementProjectNum,
    SUM(CASE WHEN project_status = 6 THEN 1 ELSE 0 END) AS acceptProjectNum,
    SUM(CASE WHEN project_status = 7 THEN 1 ELSE 0 END) AS closingProjectNum
FROM pro_project
where status = 1;