SELECT campo AS nome, count( campo ) AS numero
FROM tabella
WHERE campo = 'valore'
GROUP BY campo