Skip to content
My workspace
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;