postgresql group by month and year
snippet in sql

postgresql group by month and year

user574

date_trunc('month', col_date)