Team average

gistfile1.sql

WITH teams AS (
  SELECT
    away_team as team,
    away_score as score
  FROM  game
  WHERE game.season_year = 2014
  AND   game.season_type = 'Regular'

  UNION

  SELECT
    home_team as team,
    home_score as score
  FROM  game
  WHERE game.season_year = 2014
  AND   game.season_type = 'Regular'
)
SELECT
  team,
  avg(score)
FROM teams
GROUP BY team