SQL exercises on soccer Database: Find the country where Football EURO cup 2016 held

SQL soccer Database: Joins Exercise-6 with Solution

6. From the following tables, write a SQL query to find the country where Football EURO cup 2016 held. Return country name.

Sample table: soccer_country

Sample table: soccer_city

Sample table: soccer_venue

Sample Solution:

SQL Code:

SELECT country_name
FROM soccer_country a
JOIN soccer_city b ON a.country_id=b.country_id
JOIN soccer_venue c ON b.city_id=c.city_id
GROUP BY country_name;

Sample Output:

 country_name
--------------
 France
(1 row)

Relational Algebra Expression:

Relational Algebra Tree:

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 scorer in the final of EURO cup 2016. Return player name, jersey number and country name.
Next: From the following tables, write a SQL query to find the player who scored first goal of EURO cup 2016. Return player_name, jersey_no, country_name, goal_time, play_stage, goal_schedule, goal_half.