UST's QA engineering team needs to identify duplicate test execution records in its test reporting data. A duplicate is defined as multiple executions with the same project, test case, environment, execution date, tester, and status.
Write a PostgreSQL query that reports each duplicated execution combination and its occurrence count.
execution_id.qa_projects to include the project name and exclude executions belonging to unknown projects.| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique QA project identifier |
| project_name | VARCHAR(100) | Name of the UST QA project |
| Column | Type | Description |
|---|---|---|
| execution_idPK | INT | Unique test execution record identifier |
| project_id | INT | Reference to qa_projects |
| test_case_key | VARCHAR(30) | Functional or regression test case key |
| environment | VARCHAR(30) | Environment where the test ran |
| executed_on | DATE | Date of test execution |
| tester_email | VARCHAR(120) | Email address of the tester |
| status | VARCHAR(20) | Execution result such as passed or failed |