All questions
Advanced · SQL · Window functions
Slowest test in each suite
Commonly asked: QA data-validation rounds · ~10 min
Return suite, test_name and duration_ms of the single slowest run in each suite (ties: alphabetically first test_name). Sort by suite.
Checking your membership…
More SQL coding questions
- Each customer's latest orderAdvanced · Window functions
- Duplicate product lines in an orderIntermediate · Data quality
- Orders pointing to missing customersIntermediate · Data quality
- Salary difference from team averageAdvanced · Window functions