I am trying to make some sql exercises, and now I have come to a very confusing problem.
There is a table that has name, continent, area, population, gdp and the question is: Find each country that belongs to a continent where all populations are less than 25000000. Show name, continent and population.
So far I have this but is very very wrong
SELECT name, continent,population FROM world as a
WHERE population < ALL
(SELECT population FROM world as b where a.name = b.name and
Can someone put me on the right direction? I been thinking maybe I need a SUM function since the question tells me continent population, but I am not sure.