task Gaps & islands · hard

Longest winning streak

For the 2025 regular season, return team_id and longest_streak: each team’s longest run of consecutive wins, ordering its games by game_date then game_number.

what to return

Columns

team_idlongest_streak in this order

Rows

30 rows · any order

Watch for

Each game counts for both teams; a win means scoring more runs than the opponent.

Skill

Find the longest run of consecutive wins. Refresher: Compare rows with LAG →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

Sports dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.