calculation_month_over_month_percentage_growth_solution.sql

-- Replace with your SQL query
SELECT 
  to_date(a.date::text, 'YYYY-MM-DD') AS date, 
  a.count AS count,
  to_char(
    (count::float / lag(count) over (order by date) - 1) * 100, 
    'FM999999999.0%'
  ) AS percent_growth
FROM (
  SELECT 
    date_trunc('month', posts.created_at) AS date,
    COUNT(1) AS count
  FROM posts
  GROUP BY date
) AS a
ORDER BY a.date