SQL Joins exercises on soccer Database: Find those players who came into the field in the most last time of play

SQL soccer Database: Joins Exercise-61 with Solution

61. From the following tables, write a SQL query to find those players who came into the field at the last time of play. Return match number, country name, player name, jersey number and time in out.

Sample table: player_in_out

Sample table: player_mast

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT match_no,
       country_name,
       player_name,
       jersey_no,
       time_in_out
FROM player_in_out a
JOIN player_mast b ON a.player_id=b.player_id
JOIN soccer_country c ON a.team_id=c.country_id
WHERE time_in_out=
    (SELECT max(time_in_out)
     FROM player_in_out)
  AND in_out='I';

Sample Output:

 match_no | country_name |   player_name    | jersey_no | time_in_out
----------+--------------+------------------+-----------+-------------
       39 | Croatia      | Andrej Kramaric  |         9 |         120
       47 | Italy        | Simone Zaza      |         7 |         120
(2 rows)

Practice Online

Sample Database: soccer

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find the goal scored by the players according to their playing position. Return country name, position to play, number of goals.
Next: SQL Exercises on Hospital Database