SQL Exercise: Total number of players replaced during normal play

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

16. From the following table, write a SQL query to count the total number of players replaced during normal playtime. Return number of players as "Player Replaced".

Sample table: player_in_out

 match_no | team_id | player_id | in_out | time_in_out | play_schedule | play_half
----------+---------+-----------+--------+-------------+---------------+-----------
        1 |    1207 |    160151 | I      |          66 | NT            |         2
        1 |    1207 |    160160 | O      |          66 | NT            |         2
        1 |    1207 |    160161 | I      |          77 | NT            |         2
        1 |    1207 |    160161 | O      |          77 | NT            |         2
        1 |    1207 |    160157 | I      |           2 | ST            |         2
        1 |    1207 |    160154 | O      |           2 | ST            |         2
        1 |    1216 |    160365 | I      |          61 | NT            |         2
        1 |    1216 |    160366 | O      |          61 | NT            |         2
        1 |    1216 |    160357 | I      |          72 | NT            |         2
........
       51 |    1214 |    160316 | O      |          79 | NT            |         2

View the table

Sample Solution:

-- This SQL query calculates the count of rows in the 'player_in_out' table where the 'in_out' column has the value 'I'
-- and the 'play_schedule' column has the value 'NT', and aliases the result as "Player Replaced".

SELECT COUNT(*) as "Player Replaced"
-- COUNT(*) is an aggregate function that counts the number of rows in a result set, and the alias is set to "Player Replaced".
FROM player_in_out
-- 'player_in_out' is the name of the table being queried.
WHERE in_out='I' 
-- The WHERE clause filters rows where the 'in_out' column has the value 'I'.
AND play_schedule='NT';
-- Further filters rows where the 'play_schedule' column has the value 'NT'.

Sample Output:

 Player Replaced
-----------------
             275
(1 row)

Code Explanation:

The said query in SQL that returns a single row with a single column containing the count of players who were replaced during Normal Time ("NT") and entered the game ("I"). The column label for the result will be "Player Replaced".

Go to:

PREV : Total number of players replaced in the tournament.
NEXT : Number of players replaced in the stoppage time.

Practice Online