So I'm looking to use a custom row cell to label my data.

The table I have is above. What I'm trying to do is below:

OUTPUT:

I can get the sum of each sport but I'm having trouble making an alias for each sport on the output table (The first column)

How would I go about that? I've done an alias for a column header, but never for a row cell.

Thanks in advance!

CodePudding user response：

select   game
        ,sum(cost*flg) as cost
        
from t 
     cross join lateral (
     values 
            (basketball, 'basketball')
           ,(baseball, 'baseball')
           ,(golf, 'golf')
                        ) t2(flg, game)
group by game

Fiddle

CodePudding user response：

Use a UNION with different WHERE conditions:

select sport, sum(cost)
from 
( 
  select 'Basketball' as sport, cost
  from the_table 
  where basketball = 1
  union all
  select 'Baseball', cost
  from the_table 
  where baseball = 1
  union all
  select 'Golf', cost
  from the_table 
  where golf = 1
) t
group by sport;