SQL exercises on soccer Database: Find the name of the venue with city where the EURO cup 2016 final match was played
SQL soccer Database: Joins Exercise-1 with Solution
1. Write a query in SQL to find the name of the venue with city where the EURO cup 2016 final match was played.
Sample table: soccer_venue
Sample table: soccer_city
Sample table: match_mast
SELECT venue_name, city FROM soccer_venue a JOIN soccer_city b ON a.city_id=b.city_id JOIN match_mast d ON d.venue_id=a.venue_id AND d.play_stage='F';
venue_name | city -----------------+------------- Stade de France | Saint-Denis (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?