import pandas as pd
# Modify Person in place
def delete_duplicate_emails(person: pd.DataFrame) -> None:
person.sort_values(by='id',ascending=True,inplace=True)
person.drop_duplicates(subset='email',keep='first',inplace=True)
# return person
# Write your MySQL query statement below
delete p1 from Person p1, Person p2
where p1.email=p2.email and p1.id>p2.id