Adding 2 more questions

Medal Count Over &  host country perform in terms of medal count 



--Medal Count Over year

SELECT 
    Year,
    Country,
    SUM(COUNT(Medal)) OVER (PARTITION BY Country ORDER BY Year ROWS BETWEEN 9 PRECEDING AND CURRENT ROW) / 10.0 AS RollingAvgMedals
FROM athlete_events_clean ac
WHERE Medal IS NOT NULL
GROUP BY Year, Country
ORDER BY Year, Country;



--host country perform in terms of medal count 

SELECT Year, city, COUNT(Medal) AS TotalMedals
FROM athlete_events_clean ac
WHERE Medal IS NOT NULL
GROUP BY Year, city
ORDER BY Year;