SQL exercises on soccer Database: Find the player Who was the captain of the EURO cup 2016 winning team from Portugal

SQL soccer Database: Subqueries Exercise-21 with Solution

21. From the following tables, write a SQL query to find the captain of the EURO cup 2016 winning team from Portugal. Return the captain name.

Sample table: player_mast

Sample table: match_captain

Sample table: match_details

Sample Solution:

SQL Code:

SELECT player_name
FROM player_mast
WHERE player_id IN (
SELECT player_captain 
FROM match_captain
WHERE  team_id=(
SELECT team_id
FROM match_details
WHERE play_stage='F' AND win_lose='W'));

Sample Output:

    player_name
--------------------
 Cristiano Ronaldo
(1 row)

Practice Online

Sample Database: soccer

Query Visualization:

Duration:

Rows:

Cost:

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

Previous: From the following tables, write a SQL query to find the players who scored the last goal in the 2nd semi-final, i.e., 50th match in EURO cup 2016. Return player name, goal time, goal half, country name.
Next: From the following tables, write a SQL query to count the number of players played for ‘France’ in the final. Return 'Number of players shared fields'.