Project 3 case study 2 task 3

WITH CohortWeek AS ( SELECT user_id, DATEFORMAT(STRTODATE(createdat, '%Y-%m-%d %H:%i:%s'), '%Y-%m-%d') AS cohort_date, WEEK(STRTODATE(activatedat, '%Y-%m-%d %H:%i:%s')) AS activationweek FROM users WHERE createdat IS NOT NULL AND activatedat IS NOT NULL ), WeeklyRetention AS ( SELECT cohort_date, activation_week, COUNT(DISTINCT u.userid) AS activeusers FROM CohortWeek c LEFT JOIN users u ON c.userid = u.userid WHERE DATEADD(cohortdate, INTERVAL activationweek WEEK) <= DATEFORMAT(STRTODATE(u.activated_at, '%Y-%m-%d %H:%i:%s'), '%Y-%m-%d') GROUP BY cohortdate, activationweek ) SELECT cohort_date, activation_week, active_users, LAG(activeusers, 1) OVER(PARTITION BY cohortdate ORDER BY activationweek) AS priorweekactiveusers, (activeusers / LAG(activeusers, 1) OVER(PARTITION BY cohortdate ORDER BY activationweek)) * 100 AS retention_rate FROM WeeklyRetention ORDER BY cohortdate, activationweek; i am using this query but output is blank pls help