Hi guys,

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
 b.population <25000000)
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.

Thanks in advance