Exercise

Getting started with nested subqueries

Time to take your subqueries up a gear! You only have time to watch so much soccer, and want to know if the England Premier League is exciting as people say.

You'll compare the maximum number of goals scored in a single match across each season against the maximum for the England Premier League.

Instructions

100 XP

Complete a nested subquery to select the country_id for 'England Premier League' from league, which will be used to filter the parent subquery.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise