Case Study 2 Question 3 AGAIN

Calculate the weekly retention of user sign up cohort ? - What difference we have to find after extracting week and from where is the week extracted? SELECT EXTRACT(WEEK FROM STRTODATE(occurredat, '%d-%m-%Y %H:%i')) AS Weekno, COUNT(CASE WHEN eventname = 'completesignup' THEN user_id END) AS SignUPCount, COUNT(DISTINCT CASE WHEN eventtype = 'engagement' THEN userid END) AS engagement FROM event GROUP BY Week_no; Is it correct?