cursor attribute creation

SELECT 
  du.name,
  du.email,
  COUNT(DISTINCT pr.id) AS number_of_prs_merged,
  COUNT(DISTINCT CASE WHEN cdu.is_active THEN cdu.date END) AS cursor_days_active
FROM cursor_daily_user_metrics cdu
INNER JOIN dx_users du 
  ON du.email = cdu.email
INNER JOIN pull_requests pr 
  ON pr.dx_user_id = du.id
WHERE pr.merged >= CURRENT_DATE - INTERVAL '30 days'
  AND cdu.date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY du.name, du.email;