framework/resources/Functional/aggregates/aggregation/group_by_case/case_with_c_integer.sql

select 
	count(*),
	case when a.c_integer is null then cast(100.0 as decimal(18,2)) else cast(a.c_integer as decimal(18,2)) end
from                                            
	alltypes a   left outer join alltypes b on (a.c_integer = b.c_integer)                         
		     left outer join alltypes c on (b.c_integer = c.c_integer)                 
group by
	case when a.c_integer is null then cast(100.0 as decimal(18,2)) else cast(a.c_integer as decimal(18,2)) end
order by
	case when a.c_integer is null then cast(100.0 as decimal(18,2)) else cast(a.c_integer as decimal(18,2)) end