[Solved] SQL query returns exception

Question

Looks like the value which should ALL .. compared to must be in front of ALL

SELECT name, continent, population
FROM world 
WHERE continent IN (SELECT continent FROM world x WHERE 25000000> ALL(SELECT population FROM world y WHERE x.continent = y.continent) )

Accepted Answer

Looks like the value which should ALL .. compared to must be in front of ALL

SELECT name, continent, population
FROM world 
WHERE continent IN (SELECT continent FROM world x WHERE 25000000> ALL(SELECT population FROM world y WHERE x.continent = y.continent) )