Skip to content
Project: Footy
Football Project
Unknown table
DataFrameas
Homeadvtg_2020
variable
SELECT TEAM_NAME_HOME, COUNT(*) AS home_wins
FROM SOCCER.TBL_UEFA_2020
WHERE TEAM_HOME_SCORE > TEAM_AWAY_SCORE
GROUP BY TEAM_NAME_HOME
ORDER BY home_wins DESC
LIMIT 1;Most Wins in 2021
DataFrameas
Homeadvtg_2021
variable
SELECT TEAM_NAME_HOME, COUNT(*) AS home_wins
FROM SOCCER.TBL_UEFA_2021
WHERE TEAM_HOME_SCORE > TEAM_AWAY_SCORE
GROUP BY TEAM_NAME_HOME
ORDER BY home_wins DESC
LIMIT 1;Most Wins in 2022
Queryas
homeadvtg_2022
variable
SELECT TEAM_NAME_HOME, COUNT(*) AS home_wins
FROM SOCCER.TBL_UEFA_2022
WHERE TEAM_HOME_SCORE > TEAM_AWAY_SCORE
GROUP BY TEAM_NAME_HOME
ORDER BY home_wins DESC
LIMIT 1;