Q1 | 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 matchid, player FROM goal | |
| WHERE teamid = ‘GER‘ |
in progress
2
SQL
55 years
13 Answers
1676 views
Grand Master 0
Answers ( 13 )
The question is to select the name and id of the player from the Germany team (GER) from table Goal
Find all players and matchid from goals for team Germany.
Which German players scored goals also state the corresponding matches?
What’s query to get match-id and player details for the individuals whose team-id are GER.
Write a query about to find matchid and player from country GER?
Write a query to find the matchid and the name of player in which he played for the team Germany ‘GER’.
Write a query to return the id and player for the Germany team.
Write query to find all the matches played by team GER as well as player names.
Write a query to get the German team players who have played in the tournament
Tell the matchid and player in goal table whose teamid is ger
It’s query(fetching information) about matchid and player when the team is Germany i.e. ‘GER’ from goal table
Write a query to return the id and player for the Germany team
Write a query to return the id and player for the Germany team ???