SOQL Query for finding Duplicate Person Account by Email Address

CreateDuplicateReportAndAttachToUserProfile.cls

List<AggregateResult> results = [SELECT Count(ID), PersonEmail 
                                    FROM Account 
                                    WHERE IsPersonAccount = TRUE
                                    GROUP BY PersonEmail 
                                    HAVING Count(ID) > 1 
                                    ORDER BY Count(ID) DESC 
                                    LIMIT 2000];

String report = 'count,PersonEmail\n';

for(AggregateResult r : results) {
    
    report += r.get('numOf');
    report += ',';
    report += r.get('PersonEmail');
    report += ',';
    report +='\n';
}

ContentVersion contentVersion = new ContentVersion(
    versionData = Blob.valueOf(report),
    title = 'Duplicate Person Accounts Report',
    pathOnClient =  StringUtils.format('/Duplicate-Person-Accounts-Report-{0}.csv', DateTime.now().getTime()),
    FirstPublishLocationId = UserInfo.getUserId());

insert contentVersion; 

DuplicatePersonAccountSOQL.cls

SELECT Count(ID), PersonEmail 
FROM Account 
WHERE IsPersonAccount = TRUE
GROUP BY PersonEmail 
HAVING Count(ID) > 1 
ORDER BY Count(ID) DESC 
LIMIT 2000