Regression Testing and Reports | Dataford Interview Questions

Tell me about your experience with regression testing and reporting.

For this SQL exercise, write a query that compares the two most recent completed regression runs. Identify tests that changed from passing in the previous run to failing in the latest run, while also reporting all tests executed in the latest run.

Output

One row per test executed in the latest run.
Columns: test_case_id, test_name, current_status, previous_status, and regression_detected.
Sort by test_case_id ascending.

Schema

regression_runs

Column	Type	Description
run_idPK	INT	Unique regression run identifier
executed_at	TIMESTAMP	Time when the run was executed
completed_at	TIMESTAMP	Time when the run completed
environment	VARCHAR(30)	Execution environment

regression_results

Column	Type	Description
result_idPK	INT	Unique test result identifier
run_id	INT	Regression run that produced the result
test_case_id	INT	Test case being reported
status	VARCHAR(20)	Test outcome such as PASS, FAIL, or SKIPPED

test_cases

Column	Type	Description
test_case_idPK	INT	Unique test case identifier
test_name	VARCHAR(100)	Descriptive test name

Your question is Regression Testing and Reports. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem