SELECT count( * ) AS C, stato
FROM tabella
GROUP BY stato
ORDER BY C DESC
LIMIT 1