I'm trying to sort users with duplicate emails. However I also want to be able to see the count:

```
select ju.id, ju.email
from jhi_user ju
where ju.email in (
    SELECT ju2.email
    FROM jhi_user ju2 
    GROUP BY ju2.email
    HAVING COUNT(*) > 1)

```

I ordered them, so just having the count would be nice.