Query: nba_team_average_points_allowed

select
  team_name,
  avg(pts_allowed) as "Average Points Allowed"
from (
  select
    team_id_away as team_id,
    team_name_away as team_name,
    pts_home as pts_allowed
  from game
  union all
  select
    team_id_home,
    team_name_home,
    pts_away
  from game
) as combined
group by
  team_id
order by
  "Average Points Allowed";