Database: country_language
Question: Show the official languages and the number of countries speaking each language.
SQL:
SELECT T2.name ,  COUNT(*) FROM official_languages AS T1 JOIN languages AS T2 ON T1.language_id  =  T2.id GROUP BY T2.name