我正在尝试获得每支球队的最大游戏次数，输赢次数

SELECT
  t1.team_id,
  t1.team_name,
  t1.team_location,
  MAX(t1.game_count) AS max_game_count,
  t1.win_count,
  t1.loss_count
FROM (
  SELECT
    team_id,
    COUNT(*) AS game_count,
    SUM(CASE WHEN home_team = team_id THEN home_score > away_score ELSE away_score > home_score END) AS win_count,
    SUM(CASE WHEN home_team = team_id THEN home_score < away_score ELSE away_score < home_score END) AS loss_count
  FROM
    match_results
  GROUP BY
    team_id
) AS t1
GROUP BY
  t1.team_id, t1.team_name, t1.team_location, t1.win_count, t1.loss_count
ORDER BY
  t1.game_count DESC;