巢狀子查詢入門
是時候讓你的子查詢更進一步了！你能看球的時間有限，想知道 England Premier League 是否真的像大家說的那麼刺激。
你將把各賽季單場比賽的進球數上限，與 England Premier League 的單場進球數上限做比較。
本練習屬於課程
SQL 資料操作
練習說明
- 完成一個巢狀子查詢，從
league中選取'England Premier League'的country_id，以用來篩選外層（父）子查詢。
動手互動練習
試著完成這個範例程式碼，體驗一下這個練習。
SELECT
season,
MAX(home_goal + away_goal) AS max_goals,
(SELECT MAX(home_goal + away_goal)
FROM match
WHERE season = main.season
-- Subquery to get the max goals in an 'England Premier League' match for the same season
AND country_id IN (____)
) AS pl_max_goals
FROM match AS main
GROUP BY season;