Question

The first example shows the goal scored by a player with the last name 'Bender'. The * says to list all the columns in the table - a shorter way of saying matchid, teamid, player, gtime

Modify it to show the matchid and player name for all goals scored by Germany. To identify German players, check for: teamid = 'GER'

Answer 1

To show the matchid and player name for all goals scored by Germany, modify the table to include only goals scored by Germany and add the condition WHERE teamid = 'GER'.

Step-by-step explanation:

matchidplayer1Player12Player23Player3

To show the matchid and player name for all goals scored by Germany, you need to modify the table to only include goals scored by Germany. You would add a condition to the query: WHERE teamid = 'GER'. The resulting table would list the matchid and player name for each goal scored by a German player.

Example:
matchidplayer1Player12Player23Player3