I am doing some excercises about nested selects but cannot figure out what is the problem.
There is a table that has name, continent, area, population, gdp and the question is:
Which country has a population that is more than Canada but less than Poland? Show the name and the population
I have come with the following but is not working, can someone help me out please?
SELECT name, population FROM world where name in
(SELECT population FROM world
WHERE population > 'Canada' and population < 'Poland')