自分用覚書。 Postgresqlで月ごとの集計をするSQLは以下のような感じで。 select date_part('year', created) as year, date_part('month', created) as month, sum(price) as sum_price from sales group by year,month order by year,month;