Q10 | 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 mdate, | |
| team1, | |
| SUM(CASE WHEN teamid = team1 THEN 1 ELSE 0 END) AS score1, | |
| team2, | |
| SUM(CASE WHEN teamid = team2 THEN 1 ELSE 0 END) AS score2 FROM | |
| game LEFT JOIN goal ON (id = matchid) | |
| GROUP BY mdate,team1,team2 | |
| ORDER BY mdate, matchid, team1, team2 |
in progress
0
SQL
4 years
1 Answer
517 views
Grand Master 0
Answer ( 1 )
This question is repeated Ques , same as Q9 in this series.