Your question is SQL Duplicate Records. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |