Your question is Compare Two Tables in SQL. 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.
Persistent Systems' QA validation pipeline stores expected test results in one table and processed results in another. Write a PostgreSQL query to identify discrepancies between the two datasets.
test_case_id using a join that preserves unmatched records from both tables.MISSING_SOURCE, MISSING_TARGET, or VALUE_MISMATCH.status and result_value, treating NULL and a non-NULL value as different.test_case_id.| Column | Type | Description |
|---|---|---|
| test_case_idPK | INT | Unique expected test case identifier |
| status | VARCHAR(20) | Expected execution status |
| result_value | INT | Expected numeric result |
| Column | Type | Description |
|---|---|---|
| test_case_idPK | INT | Unique processed test case identifier |
| status | VARCHAR(20) | Actual execution status |
| result_value | INT | Actual numeric result |