SQL exercises on soccer Database: Find the teams played the first match of EURO cup 2016
SQL soccer Database: Subqueries Exercise-1 with Solution
1. Write a query in SQL to find the teams played the first match of EURO cup 2016.
Sample table: match_details
Sample table: soccer_country
SELECT match_no,country_name FROM match_details a, soccer_country b WHERE a.team_id=b.country_id AND a.match_no=1;
match_no | country_name ----------+-------------- 1 | France 1 | Romania (2 rows)
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?