w3resource
Soccer Database Exercises

SQL exercises on soccer Database: Find the club which supplied the most number of players to the 2016 EURO cup

SQL soccer Database: Subqueries Exercise-13 with Solution

13. Write a query in SQL to find the club which supplied the most number of players to the 2016 EURO cup.

Sample table: player_mast


Sample Solution:

SQL Code:

SELECT playing_club, COUNT(playing_club) 
FROM player_mast  GROUP BY playing_club 
HAVING COUNT (playing_club)=( 
SELECT MAX(mycount) 
FROM ( 
SELECT playing_club, COUNT(playing_club) mycount 
FROM player_mast 
GROUP BY playing_club) pm);

Sample Output:

 playing_club | count
--------------+-------
 Juventus     |    12
 Liverpool    |    12
(2 rows)

Query Visualization:

Duration:

Query visualization of Find the club which supplied the most number of players to the 2016 EURO cup - Duration

Rows:

Query visualization of Find the club which supplied the most number of players to the 2016 EURO cup - Rows

Cost:

Query visualization of Find the club which supplied the most number of players to the 2016 EURO cup - Cost

Practice Online


Sample Database: soccer

soccer database relationship structure

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

Previous: Write a query in SQL to find the team which was defeated by Portugal in EURO cup 2016 final.
Next: Write a query in SQL to find the player and his jersey number Who scored the first penalty of the tournament.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming