SQL exercises on soccer Database: Find the goalkeeper of the team Germany who didn't concede any goal in their group stage matches

SQL soccer Database: Subqueries Exercise-23 with Solution

23. 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.

Sample table: player_mast

Sample table: match_details

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT player_name,jersey_no 
FROM player_mast 
WHERE player_id IN(
SELECT player_gk 
FROM match_details 
WHERE  play_stage='G' and team_id IN(
SELECT country_id 
FROM soccer_country 
WHERE country_name='Germany'));

Sample Output:

  player_name  | jersey_no
---------------+-----------
 Manuel Neuer  |         1
(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 count the number of players played for ‘France’ in the final. Return 'Number of players shared fields'.
Next: From the following tables, write a SQL query to find the runners-up in Football EURO cup 2016. Return country name.