SQL exercises on soccer Database: Find the number of countries participated in the EURO cup 2016
SQL soccer Database: Basic Exercise-2 with Solution
2. Write a query in SQL to find the number of countries participated in the EURO cup 2016.
Sample table: player_mast
SELECT COUNT(DISTINCT team_id) FROM player_mast;
count ------- 24 (1 row)
Sample Database: soccer
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?