SQL Exercise: Number of shots taken in penalty shootout matches

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

22. From the following table, write a SQL query to count the number of shots taken in penalty shootouts matches. Number of shots as "Number of 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:

-- This SQL query calculates the count of rows in the 'penalty_shootout' table and aliases the result as "Number of Penalty Kicks".

SELECT COUNT(*) AS "Number of Penalty Kicks"
-- COUNT(*) is an aggregate function that counts the number of rows in a result set, and the alias is set to "Number of Penalty Kicks".
FROM penalty_shootout;
-- 'penalty_shootout' is the name of the table from which the count is being calculated.

Sample Output:

 Number of Penalty Kicks
-------------------------
                      37
(1 row)

Code Explanation:

The said query in SQL that counts the number of penalty kicks taken during a soccer match, from the table 'penalty_shootout' and aliases the result column as "Number of Penalty Kicks".

Go to:

PREV : Number of substitutes for each stage of the tournament.
NEXT : Find the number of shots scored in penalty shootouts.

Practice Online