SELECT LANGUAGE ,  CountryCode ,  max(Percentage) FROM countrylanguage GROUP BY CountryCode
What are the country codes of the different countries, and what are the languages spoken by the greatest percentage of people for each?
SELECT LANGUAGE , CountryCode , max ( Percentage ) FROM countrylanguage GROUP BY CountryCode
select language , countrycode , max ( percentage ) from countrylanguage group by countrycode
What are the country codes of the different countries , and what are the languages spoken by the greatest percentage of people for each ?