Pergunta de entrevista da empresa Microsoft

Write a SQL query that computes 7-day rolling user retention from a daily events table, then flags cohorts whose week-over-week retention dropped more than 10%.