SELECT क्लॉज़ में एक subquery जोड़ें

SELECT 
	l.name AS league,
    -- Round the average of the league's total goals
    ROUND(___(___ + m.away_goal), 2) AS avg_goals,
    -- Select and round the average total goals for the season
    (SELECT ___(___(___ + away_goal), 2) 
     FROM match
     ___ ___ = ___) AS overall_avg
FROM league AS l
LEFT JOIN match AS m
ON l.country_id = m.country_id
-- Filter for the 2013/2014 season
WHERE ___ = ___
GROUP BY ___;