반응형
SELECT
s.scenario_id,
s.scenario_name,
COUNT(DISTINCT tc.testcase_id) AS testcase_count,
COUNT(DISTINCT p.partner_id) AS partner_count,
COUNT(DISTINCT a.activity_id) AS activity_count
FROM
scenarios s
LEFT JOIN
testcases tc ON s.scenario_id = tc.scenario_id
LEFT JOIN
partners p ON s.scenario_id = p.scenario_id
LEFT JOIN
activities a ON s.scenario_id = a.scenario_id
GROUP BY
s.scenario_id, s.scenario_name;
반응형
'개발자정보' 카테고리의 다른 글
html react 변환 for (1) | 2024.12.10 |
---|---|
React Network Error 해결 방법 (0) | 2024.10.02 |
Github에 node_modules 폴더 제외하는 방법 (0) | 2024.09.26 |
redirect in react 18에 오류 해결 방법 (1) | 2024.09.24 |
This expression is not callable. Type 'typeof import("X:/xxx/node_modules/date-fns/format")' has no call signatures. (0) | 2024.09.11 |