SELECT mdate,
team1,
sum(CASE WHEN teamid=team1 THEN 1 ELSE 0 END) score1,
team2,
sum(CASE WHEN teamid=team2 THEN 1 ELSE 0 END) score2
FROM game left JOIN goal ON matchid = id
group by mdate, id, team1, team2
order by mdate, id, team1, team2
sql练习-表连接练习1
最新推荐文章于 2024-09-14 19:00:09 发布