Query: nba_team_overview

select
  full_name as 'Team Name',
  city as 'City',
  state as 'State',
  nickname as 'Nickname',
  count(*) as 'Number of Players'
from
  team as t
  join common_player_info as cpi on t.id = cpi.team_id
where
  id = $1;