Esports Ladder Standings by Split

Problem

A competitive gaming league stores end-of-split results for every roster. A win is worth 3 ladder points and a draw is worth 1; losses are worth 0. Rank rosters within each split by, in order: ladder points (highest first), then round_diff = rounds_won minus rounds_lost (highest first), then roster_name alphabetically. Use a ranking that gives tied rows the same standing. Return split_id, roster_id, roster_name, victories, stalemates, defeats, rounds_won, rounds_lost and standing. Order the result by split_id, then standing, then roster_name.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 10 rows with the columns split_id, roster_id, roster_name, victories, stalemates, defeats, rounds_won, rounds_lost, standing.

Starter code (SQL)

SELECT *
FROM split_results;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium