SQL Exercise: Number of shots taken in penalty shootout matches

SQL soccer Database: Exercise-22 with Solution

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

Sample Solution:

SELECT COUNT(*) AS "Number of Penalty Kicks"
FROM penalty_shootout;

Sample Output:

 Number of Penalty Kicks
-------------------------
                      37
(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 SQL Exercise: Number of substitutes for each stage of the tournament.
Next SQL Exercise: Find the number of shots scored in penalty shootouts.