Find duplicate emails with HAVING

This query finds duplicate email addresses in a clients table:

 SELECT email, count(*), group_concat(name, ',') AS names

 FROM clients

 GROUP BY email

 HAVING count(*) > 1

Let's go through that query one step at a time: