经典比分，累计计数题
SELECT
mdate,
team1,
SUM(CASE WHEN team1=teamid THEN 1 ELSE 0 END) score1,
team2,
SUM(CASE WHEN team2=teamid THEN 1 ELSE 0 END) score2
FROM game a,goal b
WHERE a.id = b.matchid
GROUP BY mdate,team1,team2
ORDER BY mdate,matchid,team1,team2
