Database: world_1
Question: What are the country codes of the different countries, and what are the languages spoken by the greatest percentage of people for each?
SQL:
SELECT LANGUAGE ,  CountryCode ,  max(Percentage) FROM countrylanguage GROUP BY CountryCode