如何在大表中找到具有重复字段的行？

I have a table with 1.5M+ rows for recording downloads from a website which has email address of the one who has downloaded something. I want to find those who have downloaded more than 100 times. This is what I have tested but the I have a table with 1.5M+ rows for recording do