1.测试人员发现有效bug数排行。条件:时间
SELECT
COUNT(*) num,
openedBy,
realname
FROM
zt_bug b
INNER JOIN zt_user u ON u.account = b.openedBy
WHERE
DATE_FORMAT(b.openedDate, '%Y%m') = '202009'
AND b.resolution NOT IN (
'bydesign',
'duplicate',
'external',
'notrepro',
'willnotfix'
)
GROUP BY
b.openedBy
ORDER BY
num DESC;
2.研发人员发生bug数排行。条件:时间
SELECT
COUNT(*) num,
openedBy,
realname
FROM
zt_bug b
INNER JOIN zt_user u ON u.account = b.resolvedBy
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载