Distinct Failing Test Cases | Dataford Interview Questions

Write a SQL query to find the number of distinct failing test cases per release.

Use the test_results table. Count only rows whose status is FAIL, and exclude releases with no failing test cases.

Output

test_results

Column	Type	Description
result_idPK	INT	Unique identifier for a test result
release	VARCHAR(50)	Release tested
test_case_id	VARCHAR(50)	Identifier of the executed test case
status	VARCHAR(20)	Test result status, such as PASS or FAIL

Your question is Distinct Failing Test Cases. Start with the requirements and the one table 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.

Write a SQL query to find the number of distinct failing test cases per release.

Use the test_results table. Count only rows whose status is FAIL, and exclude releases with no failing test cases.

test_results

Column	Type	Description
result_idPK	INT	Unique identifier for a test result
release	VARCHAR(50)	Release tested
test_case_id	VARCHAR(50)	Identifier of the executed test case
status	VARCHAR(20)	Test result status, such as PASS or FAIL

Your question is Distinct Failing Test Cases. Start with the requirements and the one table 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.