select colonna, count(colonna) from tabella group by colonna