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_player_experience_distribution_by_team
Usage
powerpipe query nba.query.nba_player_experience_distribution_by_team
SQL
select team_name, sum(case when season_exp = 0 then 1 else 0 end) as Rookies, sum(case when season_exp between 1 and 3 then 1 else 0 end) as "1_to_3_years", sum(case when season_exp between 4 and 6 then 1 else 0 end) as "4_to_6_years", sum(case when season_exp >= 7 then 1 else 0 end) as "7_years_plus"from common_player_infogroup by team_nameorder by team_name;
Dashboards
The query is used in the dashboards: