如何查询计算球队的特定胜利并找到系列的胜利者

如何查询计算球队的特定胜利并找到系列的胜利者

我将使用大小写，计数和分组

select winner, count(winner) from    (select case radiant_win   when 1 then radiant_name   else dire_name end as winner     FROM test.`match` ) as tempgroup by winner;

• test.’match’是我在MySQL中创建的测试表

更新

更新问题后，我找不到start_time，radiant_team_id和dire_team_id作为您在评论中发布的内容。

以下答案可能不是您想要的答案，因为您在更新问题后仍不清楚我的问题。

select *, count(winner) as count from (select case radiant_win  when 1 then radiant_name  else dire_name         end as winner,         radiant_team_id,         dire_team_id,        series_id,        series_type    from test.`matches`     where league_id = 2096 andstart_time >= 1415938900 and          ((radiant_team_id= 1848158 and dire_team_id= 15) or (radiant_team_id= 15 and dire_team_id= 1848158))     ) as tempgroup by winner;