SQL_Zoo
SQL_Zoo copied to clipboard
answer 11, 12, 13 are incorrect. can you check? solution 6
mdate or matchid are also to be added in GROUP BY
SELECT matchid,mdate, COUNT(matchid) FROM game JOIN goal ON matchid = id WHERE (team1 = 'POL' OR team2 = 'POL') GROUP BY matchid, mdate