Unlock Business Insights Without Writing Code

SELECT 
  date_trunc('month', created_at) as month,
  COUNT(distinct user_id) as active_users,
  ROUND(COUNT(distinct user_id)::numeric / LAG(COUNT(distinct user_id)) 
    OVER (ORDER BY date_trunc('month', created_at)), 2) as retention_rate
FROM user_sessions
WHERE created_at > now() - interval '12 months'
GROUP BY month
ORDER BY month;