SELECT LANGUAGE ,  CountryCode ,  max(Percentage) FROM countrylanguage GROUP BY CountryCode
What is the language spoken by the largest percentage of people in each country?
SELECT LANGUAGE , CountryCode , max ( Percentage ) FROM countrylanguage GROUP BY CountryCode
select language , countrycode , max ( percentage ) from countrylanguage group by countrycode
What is the language spoken by the largest percentage of people in each country ?