for Q.11 For every match involving 'POL', show the matchid, date and the number of goals scored

[dubeyji10]

used multiple group by

SELECT matchid, mdate, COUNT(player) as 'goals scored' FROM goal JOIN game ON matchid = id WHERE 'POL' IN (team1, team2) GROUP BY matchid,mdate