04_JOIN_UEFA EURO 2012_4.sql

/* Problem Statement:

Use the same JOIN as in the previous question.

Show the team1, team2 and player for every goal scored by a player called Mario player LIKE 'Mario%'

*/

-- Solution: 

SELECT team1, team2, player FROM 
game JOIN goal ON (id = matchid)
WHERE player LIKE '%Mario%';