SQL Subqueries exercises on soccer Database: Find the stage of match where the penalty kick number 23 had been taken

SQL soccer Database: Subqueries Exercise-30 with Solution

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.

Sample table: match_mast

Sample table: penalty_shootout

Sample Solution:

SQL Code:

SELECT match_no,
       play_stage
FROM match_mast
WHERE match_no=
    (SELECT match_no
     FROM penalty_shootout
     WHERE kick_id=23);

Sample Output:

 match_no | play_stage
----------+------------
       47 | Q
(1 row)

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 player of 'Portugal' who taken the seventh kick against 'Poland'. Return match number, player name and kick number.
Next: From the following tables, write a SQL query to find the venues where penalty shoot-out matches played. Return venue name.