Your question is Missing Values in Required Join Column. 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.
Apex Systems QA reporting needs to flag test runs that cannot be linked to a defined test case. These records should be identified before execution results are included in quality metrics.
Write a PostgreSQL query that returns QA test runs where the required test_case_id join column is NULL. Preserve the run record even though it has no matching test case.
LEFT JOIN from test_runs to test_cases.test_runs.test_case_id IS NULL.run_id ascending.| Column | Type | Description |
|---|---|---|
| run_idPK | INT | Unique identifier for the test run |
| test_case_id | INT | Required reference to test_cases.test_case_id |
| environment | VARCHAR(30) | Environment where the test ran |
| status | VARCHAR(20) | Execution status |
| Column | Type | Description |
|---|---|---|
| test_case_idPK | INT | Unique test case identifier |
| test_case_name | VARCHAR(150) | Descriptive QA test case title |
| component | VARCHAR(60) | Application component under test |