nba_active_players_countnba_home_away_top_points_by_teamnba_home_away_wins_by_teamnba_player_birth_countries_allnba_player_experience_distribution_by_teamnba_player_experience_distribution_by_team_detailnba_player_nationalities_in_teamnba_rookie_players_countnba_team_arena_capacitiesnba_team_arena_capacitynba_team_average_points_allowednba_team_average_points_per_gamenba_team_foundation_yearnba_team_inputnba_team_overviewnba_team_performance_over_timenba_team_total_winsnba_teams_countnba_top_10_experienced_players_in_teamnba_top_10_team_by_total_winsnba_top_teams_by_points_per_game
Query: nba_team_average_points_allowed
Usage
powerpipe query nba.query.nba_team_average_points_allowed
SQL
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 combinedgroup by team_idorder by "Average Points Allowed";
Dashboards
The query is used in the dashboards: