Select
substr(COLUMNNAME,1,1),
count(*)
from
TABLENAME
Group by
substr(columnname,1,1)


U r Done