SQL exercises on soccer Database: Find the number of players played for france in the final

SQL soccer Database: Subqueries Exercise-22 with Solution

22. 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'.

Sample table: player_in_out

Sample table: match_mast

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT COUNT(*)+11 as "Number of players shared fields" 
FROM player_in_out 
WHERE match_no=(
SELECT match_no 
FROM match_mast 
WHERE play_stage='F')
AND in_out='I' 
AND team_id=(
SELECT country_id 
FROM soccer_country 
WHERE country_name='France');

Sample Output:

 Number of players shared fields
---------------------------------
                              14
(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 captain of the EURO cup 2016 winning team from Portugal. Return the captain name.
Next: From the following tables, write a SQL query to find the Germany goalkeeper who didn't concede any goal in their group stage matches. Return goalkeeper name, jersey number.