Write an SQL query to calculate a running total of passed test cases by date.
Use the test_case_results table. Count only rows with outcome PASSED; rows with a NULL executed_on are ignored.
execution_date, passed_count, and cumulative running_total.execution_date ascending.| Column | Type | Description |
|---|---|---|
| result_idPK | INTEGER | Unique identifier for the test result |
| test_case_id | INTEGER | Identifier of the executed test case |
| executed_on | DATE | Date on which the test case was executed |
| outcome | VARCHAR(30) | Recorded execution outcome |