Датасет ncaa_basketball, таблица mbb_games_sr
https://console.cloud.google.com/bigquery?project=bright-proxy-245105&authuser=1&p=bigquery-public-data&d=ncaa_basketball&t=mbb_games_sr&page=table
Визуализировать динамику максимального победного счета по командам за каждый месяц сезона. В каждом месяце вывести топ-10 команд по максимальному счету. Сезон 2017 года.
SELECT
FORMAT_DATETIME("%Y-%m",
DATE(gametime)) AS month,
CASE
WHEN h_points_game>a_points_game THEN h_name
WHEN h_points_game<a_points_game THEN a_name
ELSE
"Draw"
END
AS winners,
MAX(CASE
WHEN h_points_game>a_points_game THEN h_points_game
WHEN h_points_game<a_points_game THEN a_points_game
ELSE
0
END
) AS max_winner_score
FROM
`bigquery-public-data.ncaa_basketball.mbb_games_sr`
WHERE
season=2017
GROUP BY
1,
2
ORDER BY
month
https://datastudio.google.com/embed/reporting/66830b68-d2da-4529-9874-a48bef861c4a/page/hjwsB