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
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;
player_name | country_name -------------+-------------- Pepe | Portugal (1 row)
Sample Database: soccer
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?