This repository contains SQL queries and data analysis results from the game between Aris and Olympiakos in 2023.
The SQL queries provided analyze various aspects of the game, focusing on player and team performance metrics.
Identifies the top players based on the total number of open play passes made during the game.
Calculates the total number of open play passes made by each team throughout the game.
Lists the players with the highest number of unsuccessful touches during the game.
Provides the total count of unsuccessful touches for each team during the game.
Identifies the player with the highest effective head clearances made during the game.
Calculates the total number of possessions won in the defensive third by each team.
Lists the players with the highest number of possessions won in the defensive third.
Identifies the player with the highest overall defensive contributions, considering metrics like aerials won, duels won, interceptions, tackles, ball recoveries, blocked passes, effective blocked crosses, and effective clearances.
Identifies the player with the highest attacking contributions specifically in midfield for team ARIS. Metrics considered include assists, scoring attempts, goals, on-target scoring attempts, successful passes into the penalty area, and successful passes in the final third.
These SQL queries can be executed against the dataset games.aris_osfp_2023
to retrieve specific performance metrics and insights from the game between Aris and Olympiakos in 2023.
The data used in these queries is sourced from the game dataset games.aris_osfp_2023
.