i am trying to alias the pivot column to scenario1, scenario2, scenario3 instead of 1,2,3. I am getting error.

```
select *
from (select *
      from (select s.campaign_id campaign_id, s.scenario_index scenario_index 
            from scenario s, campaign c where s.campaign_id = c.campaign_id)
      pivot (max(scenario_index)for scenario_index in (1,2,3))
     )a 

```

thank you, aggregation gives the result with alias now. The requirement i have is to combine these columns with another query which is 

```
select  CASE WHEN AWARD_TYPE = 0 THEN award_rate||' points'
                                        when AWARD_TYPE = 1   then Award_rate||' %'
                                        when award_type=2  then RATIO_POINTS||' points per '||RATIO_MON_UNIT||' AED' End
                            from  points_rule p
                            where c.pt_basic_rule_id = p.point_rule_id ) as pool_awards, 

```

this query comes as a column and then the scenario1, 2,3 should come as 3 columns with the value of the pool\_award based on the campaign\_id