LeetCode Delete Duplicate Emailsを解いてみた

問題

https://leetcode.com/problems/delete-duplicate-emails/

解いた

DELETE P FROM Person AS P,
Person AS PP
WHERE P.email = PP.email
    AND P.ID > PP.id;

結果