Grouping by month and year in Postgres

year_month_group.sql

SELECT CAST(date_part('year', date) AS varchar(4)) || '-' || CAST(date_part('month', date) AS varchar(2)) AS month, SUM(amount)
FROM withdrawals
WHERE some_predicate()
GROUP BY month
ORDER BY month;