Q8 | Guess the question
Question
All you have to do is to go through the code and comment the question for which the following is an answer of
| SELECT id, mdate, COUNT(player) | |
| FROM game | |
| JOIN goal ON (id=matchid AND (team1 = ‘GER‘ OR team2 = ‘GER‘) AND teamid=‘GER‘) | |
| GROUP BY id, mdate |
in progress
0
SQL
4 years
1 Answer
478 views
Grand Master 0
Answer ( 1 )
Write a query to fetch the matchid , matchdate on which match played and number of players who played for the teamid = ‘GER’ , irrespective of teamid GER put in team1 or team2.