w3resource
Soccer Database Exercises

SQL exercises on soccer Database: Find the player who was selected for the Man of the Match Award in the finals of EURO cup 2016

SQL soccer Database: Joins Exercise-34 with Solution

34. Write a query in SQL to find the player who was selected for the Man of the Match Award in the finals of EURO cup 2016.

Sample table: soccer_country


Sample table: match_mast


Sample table: player_mast


Sample Solution:

SQL Code:

SELECT a.player_name, b.country_name
FROM player_mast a 
JOIN match_mast c ON c.plr_of_match=a.player_id
AND c.play_stage='F'
JOIN soccer_country b
ON a.team_id=b.country_id;

Sample Output:

 player_name | country_name
-------------+--------------
 Pepe        | Portugal
(1 row)

Practice Online


Sample Database: soccer

soccer database relationship structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to find the captain and goal keeper with other information for all the matches for all the team.
Next: Write a query in SQL to find the substitute players who came into the field in the first half of play within normal play schedule.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming