Output: Dedupe Keep Latest

Interviewer prompt: What id remains after dedupe keeping latest updated_at per lower(email)? DELETE logic keeps rn = 1 with ROW_NUMBER PARTITION BY lower(email) ORDER BY updated_at DESC, id DESC.