SELECT email,
  COUNT(email) AS NumOccurrences
 FROM User
 GROUP BY email
 HAVING ( COUNT(email) > 1 )==MySQL Query GROUP BY day / month / year]==
SELECT COUNT(id),YEAR(date), MONTH(date)
from dbname
GROUP BY YEAR(date), MONTH(date);