mysql 统计重复项

我有一张这样的桌子

mysql> desc user_changes;
+----------+--------------+------+-----+---------+-------+ 
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+ 
| id       | varchar(16)  | NO   | PRI |         |       | 
| email    | varchar(255) | YES  | MUL | NULL    |       |  
| products | longtext     | YES  |     | NULL    |       | 
+----------+--------------+------+-----+---------+-------+ 
3 rows in set (0.00 sec)

我需要创建一个查询来计算通过电子邮件发送的所有重复项，如下所示

 | 20061129180346 | tes[email protected] /cdn-cgi/l/email-protection | 1^31^9 
 | 20061129330638 | [email protected] /cdn-cgi/l/email-protection | 1^31^9

SELECT    count(*), email
FROM      user_changes
GROUP BY  email
HAVING    count(*) > 1

最后 （HAVING) 子句将选择范围限制为大于 1 的电子邮件计数，例如重复。