SQL Exercise: Number of shots missed or saved in penalty shootouts

Last update on January 13 2026 12:20:22 (UTC/GMT +8 hours)

24. From the following table, write a SQL query to count the number of shots missed or saved in penalty shootout matches. Return number of shots missed as "Goal missed or saved by Penalty Kicks".

Sample table: penalty_shootout

 kick_id | match_no | team_id | player_id | score_goal | kick_no
---------+----------+---------+-----------+------------+---------
       1 |       37 |    1221 |    160467 | Y          |       1
       2 |       37 |    1213 |    160297 | Y          |       2
       3 |       37 |    1221 |    160477 | N          |       3
       4 |       37 |    1213 |    160298 | Y          |       4
       5 |       37 |    1221 |    160476 | Y          |       5
       6 |       37 |    1213 |    160281 | Y          |       6
       7 |       37 |    1221 |    160470 | Y          |       7
       8 |       37 |    1213 |    160287 | Y          |       8
       9 |       37 |    1221 |    160469 | Y          |       9
.......
      37 |       47 |    1208 |    160166 | Y          |      18

View the table

Sample Solution:

SQL Code:

-- This SQL query calculates the count of rows in the 'penalty_shootout' table
-- where the 'score_goal' column has the value 'N', indicating goals missed or saved by penalty kicks.
-- It aliases the result as "Goal missed or saved by Penalty Kicks".

SELECT COUNT(*) AS "Goal missed or saved by Penalty Kicks"
-- COUNT(*) is an aggregate function that counts the number of rows in a result set, and the alias is set to "Goal missed or saved by Penalty Kicks".
FROM penalty_shootout
-- 'penalty_shootout' is the name of the table being queried.
WHERE score_goal='N';
-- The WHERE clause filters rows where the 'score_goal' column has the value 'N'.

Sample Output:

 Goal missed or saved by Penalty Kicks
---------------------------------------
                                     9
(1 row)

Code Explanation:

The said query in SQL that counts the number of penalties that were either missed or saved by the goalkeeper from the table 'penalty_shootout' and aliases the result column as "Goal missed or saved by Penalty Kicks". The filter condition WHERE clause only consider those penalty kicks where a goal was not scored, i.e., the value of the "score_goal" column is 'N'.

Go to:

PREV : Find the number of shots scored in penalty shootouts.
NEXT : List of players with shot numbers in penalty shootouts.

Practice Online