answer 11, 12, 13 are incorrect. can you check? solution 6

Open michaelzeng25 opened this issue 8 years ago • 1 comments

May 03 '17 04:05 michaelzeng25

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

Nov 29 '20 06:11 jithendray