framework/resources/Functional/aggregates/aggregation/group_by_expression/extract_month_from_date_with_cast.sql

select  
	cast(extract(month from c_date) as bigint) 
from 
	alltypes  
group by 
	cast(extract(month from c_date) as bigint) 
order by 
	cast(extract(month from c_date) as bigint);