Q4 | 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 team1, team2, player
FROM game
JOIN goal ON (id=matchid AND player LIKE Mario%)
in progress 0
TheDataMonk 4 years 1 Answer 515 views Grand Master 0

Answer ( 1 )

  1. Find the player whose name starts with “Mario” and done any goal in the whole game.
    Mention the team names as well who played match against each other, along with the player name.

Leave an answer

Browse
Browse