SQL Subqueries exercises on soccer Database: Find the venues where penalty shootout matches played
SQL soccer Database: Subqueries Exercise-31 with Solution
Write a query in SQL to find the venues where penalty shootout matches played.
Sample table: soccer_venue
Sample table: match_mast
Sample table: penalty_shootout
SELECT venue_name FROM soccer_venue WHERE venue_id IN (SELECT venue_id FROM match_mast WHERE match_no IN (SELECT DISTINCT match_no FROM penalty_shootout));
venue_name ------------------------- Stade VElodrome Stade de Bordeaux Stade Geoffroy Guichard (3 rows)
SQL Code Editor:
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?