SELECT *,COUNT(data) AS numero FROM tabella
GROUP BY DAYOFMONTH(data)