или так

select some_field, count(*) as f
from some_table
group by some_field
order by f