Subquery inside select

Add a subquery to the SELECT clause

Subqueries in SELECT statements generate a single value that allow you to pass an aggregate value down a data frame. This is useful for performing calculations on data within your database.
In the following exercise, you will construct a query that calculates the average number of goals per match in each country's league.