Describe how you would design an automated test strategy for a web application with frontend and backend components, including what tools you would use, how you would structure test cases, manage test data, and integrate tests into a CI/CD pipeline.
For this SQL exercise, use the provided test case, test run, and test result data to identify automated tests that require attention based on recent CI history.
Output
- Return one row per test with at least two executions in the three most recent completed CI runs, where the latest result failed and the failure rate is at least 50%.
- Return
case_id, test_name, component, failure_count, execution_count, failure_rate, latest_status, and latest_run_id.
- Order by
failure_rate descending, then test_name ascending.
