Query to delete duplicates

I’d appreciate the assistance if you don’t mind! Thanks in advance.