w3resource

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. From the following table, write a SQL query to count the number of countries participated in the EURO cup 2016.

Sample table: player_mast


Sample Solution:

SELECT COUNT(DISTINCT team_id) 
FROM player_mast;

Sample Output:

 count
-------
    24
(1 row)

Relational Algebra Expression:

Relational Algebra Expression: Find the number of countries participated in the EURO cup 2016.

Relational Algebra Tree:

Relational Algebra Tree: Find the number of countries participated in the EURO cup 2016.

Practice Online



Sample Database: soccer

soccer database relationship structure

Query Visualization:

Duration:

Query visualization of Find the number countries participated in the EURO cup 2016 - Duration

Rows:

Query visualization of Find the number countries participated in the EURO cup 2016 - Rows

Cost:

Query visualization of Find the number countries participated in the EURO cup 2016 - Cost

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

Previous: From the following table, write a SQL query to count the number of venues for EURO cup 2016. Return number of venues.
Next: From the following table, write a SQL query to find the number of goals scored in EURO cup 2016 within normal play schedule.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



SQL: Tips of the Day

Nested select statement in SQL Server.

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a 

or to be more explicit

SELECT a.name FROM (SELECT name FROM agentinformation) a  

Database: SQL Server

Ref: https://bit.ly/3Qruiu5