How select count of each item in database by SQL?

Question

for example we have a country table by country_name column and language column. now we want all languages and count of countries that have that language by single program.