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