mysql - 获得最后十场胜利

Question

我实际上有一个匹配表，id，team1，team2，date其中 team1 是比赛的获胜者，我试图获得一支球队在最近十场比赛中取得了多少场胜利。

我设法通过这种方式获得了球队的最后十场比赛，但是我找不到获得胜利次数的方法

SELECT * 
FROM matches
WHERE time1 = 13 OR time2 = 13 
ORDER BY data DESC, id ASC 
LIMIT 10

Answer 1

试试这个:

SELECT team1, COUNT(team1) as 'wins'
FROM matches
WHERE team1 = 13 or team2 = 13
GROUP BY team1
LIMIT 10

它应该给你这样的结果

team1 | wins
=====   ====
Bears    5
Tigers   3
Cubs     2