sqlzoo-solutions/join.sql , Question 13

[maz369]

It seems GROUP BY mdate,team1,team2 should be updated to mdate,matchid,team1,team2 otherwise it returns an error. Since you are using ORDER BY on matchid, first GROUP BY should be used for it.
What do you think?

[MeemsZee]

I think because we are displaying it on the table, it isn't necessary. I've tried it both ways, there are no error pop ups for either variation