SQL exercises on soccer Database: Find the scorer of only goal along with his country and jersey number in the final of EURO cup 2016
SQL soccer Database: Joins Exercise-5 with Solution
5. Write a query in SQL to find the scorer of only goal along with his country and jersey number in the final of EURO cup 2016.
Sample table: goal_details
Sample table: player_mast
Sample table: soccer_country
SELECT player_name,jersey_no,country_name FROM goal_details a JOIN player_mast b ON a.player_id=b.player_id JOIN soccer_country c ON a.team_id=c.country_id WHERE play_stage='F';
player_name | jersey_no | country_name -------------+-----------+-------------- Eder | 9 | Portugal (1 row)
Sample Database: soccer
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?