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

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