SQL Subqueries exercises on soccer Database: Find the venues where penalty shootout matches played

SQL soccer Database: Subqueries Exercise-31 with Solution

From the following tables, write a SQL query to find the venues where penalty shoot-out matches played. Return venue name.

Sample table: soccer_venue

Sample table: match_mast

Sample table: penalty_shootout

Sample Solution:

SQL Code:

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));

Sample Output:

       venue_name
-------------------------
 Stade VElodrome
 Stade de Bordeaux
 Stade Geoffroy Guichard
(3 rows)

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 stage of match where penalty kick number 23 had been taken. Return match number, play_stage.
Next: From the following tables, write a SQL query to find the date when penalty shootout matches played. Return playing date.