SELECT emailaddress, COUNT(*) AS frequency
    FROM tablename
    GROUP BY emailaddress ;

SELECT frequency, COUNT(*) AS emailadresses
FROM
  ( SELECT COUNT(*) AS frequency           -- we don't need email any more
    FROM tablename
    GROUP BY emailaddress
  ) AS x
GROUP BY frequency ;