Hard · IPL cricket · Tables: matches
For season '2024', keep matches with a non-NULL, nonblank winner. For every retained match, show integer match_id, date, winner, and that winner's cumulative number of wins through this match. Count all match types. Order each team's timeline by date then numeric id. Return columns match_id, date, winner, wins_so_far, in that order. Order the final result by date ascending, then numeric match_id ascending. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text.