Scalar expressions after aggregation should be supported.

select segment, count(*) as num_customers, segment*50 as segment_base
from segments
group by segment
order by segment, num_customers ;

select s, num_customers, s *50 as segment_base
from
(select segment as s, count(*) as num_customers
from segments
group by segment
order by segment, num_customers) a;