如何返回postgres最近12个月内每个月发生的所有记录的总和

SELECT DATE_TRUNC('month', date_column) AS month, SUM(record_column) AS total_records
FROM your_table
WHERE date_column >= CURRENT_DATE - INTERVAL '12 months'
GROUP BY month
ORDER BY month;

SELECT TO_CHAR(month, 'YYYY-MM') AS month, COALESCE(total_records, 0) AS total_records
FROM (
  SELECT generate_series(
           DATE_TRUNC('month', CURRENT_DATE - INTERVAL '11 months'),
           DATE_TRUNC('month', CURRENT_DATE),
           '1 month'
         ) AS month
  LEFT JOIN (
    SELECT DATE_TRUNC('month', date_column) AS month, SUM(record_column) AS total_records
    FROM your_table
    WHERE date_column >= CURRENT_DATE - INTERVAL '12 months'
    GROUP BY month
  ) AS subquery
  ON month = subquery.month
) AS result
ORDER BY month;