w3resource
Soccer Database Exercises

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


Sample Solution:

SQL Code:

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';

Sample Output:

  player_name | jersey_no | country_name
-------------+-----------+--------------
 Eder        |         9 | Portugal
(1 row)

Practice Online


Sample Database: soccer

soccer database relationship structure

Query Visualization:

Duration:

Query visualization of Find the scorer of only goal along with his country and jersey number in the final of EURO cup 2016 - Duration

Rows:

Query visualization of Find the scorer of only goal along with his country and jersey number in the final of EURO cup 2016 - Rows

Cost:

Query visualization of Find the scorer of only goal along with his country and jersey number in the final of EURO cup 2016 - Cost

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

Previous: Write a query in SQL to find the highest individual scorer in EURO cup 2016.
Next: Write a query in SQL to find the country where Football EURO cup 2016 held.

What is the difficulty level of this exercise?