sql精进之一步一步学习

SELECT
    sys_dept.dept_name,
    COUNT(IF(wy_advise_type = 1, 1, NULL)) AS '投诉数量',
    COUNT(IF(wy_advise_type = 2, 1, NULL)) AS '建议数量'
FROM
    wy_advise
    LEFT JOIN wy_housing_estate ON wy_housing_estate.housing_estate_id = wy_advise.housing_estate_id
    RIGHT JOIN sys_dept ON sys_dept.dept_id = wy_housing_estate.dept_id 
WHERE
    sys_dept.dept_type = 2 
GROUP BY
    sys_dept.dept_id

ifnull(count(1), 0)

https://blog.csdn.net/qq_45525848/article/details/132794689