sql中当月的累积和缺失值

SELECT date, value, SUM(value) OVER (ORDER BY date) AS cumulative_sum
FROM table_name
WHERE EXTRACT(MONTH FROM date) = EXTRACT(MONTH FROM CURRENT_DATE)

WITH date_range AS (
  SELECT generate_series(
           DATE_TRUNC('MONTH', CURRENT_DATE),
           DATE_TRUNC('MONTH', CURRENT_DATE) + INTERVAL '1 MONTH' - INTERVAL '1 day',
           INTERVAL '1 day'
         ) AS date
)
SELECT date_range.date, COALESCE(table_name.value, 0) AS value
FROM date_range
LEFT JOIN table_name ON date_range.date = table_name.date
WHERE EXTRACT(MONTH FROM date_range.date) = EXTRACT(MONTH FROM CURRENT_DATE)
ORDER BY date_range.date