w3resource

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)

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".

Practice Online



Sample Database: soccer

soccer database relationship structure

Query Visualization:

Duration:

Query visualization of Find the number of shots taken in penalty shootout matches - Duration

Rows:

Query visualization of Find the number of shots taken in penalty shootout matches - Rows

Cost:

Query visualization of Find the number of shots taken in penalty shootout matches - 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.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.

SQL: Tips of the Day

What is the best way to paginate results in SQL Server?

SELECT  *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY OrderDate ) AS RowNum, *
          FROM      Orders
          WHERE     OrderDate >= '1980-01-01'
        ) AS RowConstrainedResult
WHERE   RowNum >= 1
    AND RowNum < 20
ORDER BY RowNum

Database: SQL Server

Ref: https://bit.ly/3MGrNlk

 





We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook