sql 统计禅道系统中所有人已解决的bug(项目、产品、人)

SELECT
    pd.NAME AS 产品,
    pj.NAME AS 项目,
    b.id AS bug_id,
    b.title AS bug标题,
    la2.VALUE AS 类型,
    b.`status`,
    u1.realname AS 提交人,
    u2.realname AS 解决人,
    la.VALUE AS 解决方案,
    b.openedDate AS 创建时间,
    b.resolvedDate AS 解决时间 
FROM
    zt_bug  AS b
    INNER JOIN zt_product pd ON b.product = pd.id
    LEFT JOIN zt_project pj ON pj.id = b.project
    JOIN zt_user u1 ON u1.account = b.openedBy
    JOIN zt_user u2 ON u2.account = b.resolvedBy
    JOIN zt_lang la ON b.resolution = la.KEY 
    AND la.section = 'resolutionList'
    JOIN zt_lang la2 ON b.type = la2.KEY 
    AND la2.lang = 'zh-cn' 
--   WHERE
--      b.openedDate > '2022-09-21 00:00:00' 
--     AND 
--      b.confirmed = '1'   
ORDER BY
    b.openedDate DESC;