01_JOIN_UEFA EURO 2012_1.sql

/* Problem Statement:

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'

*/

-- Solution: 

SELECT matchid, player FROM goal 
WHERE teamid LIKE 'GER';