Query: nba_team_total_wins

select
  'Total Wins' as label,
  sum(case when wl_home = 'W' then 1 else 0 end + case when wl_away = 'W' then 1 else 0 end) as value
from
  game
where
  team_id_home = $1 or team_id_away = $1;