SQL Pass Fail by Tester and Date | Dataford Interview Questions

Write a SQL query to summarize pass/fail results by tester and date.

Use the test_results table. Include only rows with a non-null tester, a non-null test date, and a result of pass or fail. Rows with null tester names, null dates, or other result values must be ignored.

Output

One row per tester and test date, with tester_name, test_date, pass_count, fail_count, and total_tests.
Order by tester_name ascending, then test_date ascending.

Schema

test_results

Column	Type	Description
result_idPK	INT	Unique identifier for the test result
tester_name	VARCHAR(50)	Name of the tester who ran the test
test_date	DATE	Date on which the test was run
result	VARCHAR(30)	Outcome of the test execution

Your question is SQL Pass Fail by Tester and Date. 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.

Problem

Write a SQL query to summarize pass/fail results by tester and date.

Output

One row per tester and test date, with tester_name, test_date, pass_count, fail_count, and total_tests.
Order by tester_name ascending, then test_date ascending.

Schema

test_results

Column	Type	Description
result_idPK	INT	Unique identifier for the test result
tester_name	VARCHAR(50)	Name of the tester who ran the test
test_date	DATE	Date on which the test was run
result	VARCHAR(30)	Outcome of the test execution

Your question is SQL Pass Fail by Tester and Date. 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.