Database: world_1
Question: What is the language spoken by the largest percentage of people in each country?
SQL:
SELECT LANGUAGE ,  CountryCode ,  max(Percentage) FROM countrylanguage GROUP BY CountryCode