How do I include fields from different records with a common value of another fields? I have in a table country information with the county name, primary language and population.
I’m trying to write a query that allows me to print the names of the countries with the same primary language.
I would appreciate any help 
select name
from countries
where primary_language=‘EN’;
than you! I appreciate your response.
What if there are several languages? I have included several countries. For instance, the UK and the US language is English. Spain, Costa Rica and Mexico speak Spanish…So the programs needs to check the primary language and print the language with countries speaking the language