Skip to content
Spinner
DataFrameas
df
variable
SELECT 
    COUNT(*) AS total_matches,
    SUM(TEAM_HOME_SCORE) AS total_home_goals,
    SUM(TEAM_AWAY_SCORE) AS total_away_goals,
    MAX(TEAM_HOME_SCORE) AS max_home_goals,
    MAX(TEAM_AWAY_SCORE) AS max_away_goals,
    MIN(TEAM_HOME_SCORE) AS min_home_goals,
    MIN(TEAM_AWAY_SCORE) AS min_away_goals
FROM SOCCER.TBL_UEFA_2020;