在选择中选择

Question

我试着做一个与select有关的练习，我有错误语法，我不知道why.The练习，它问我‘

哪个国家的人口比加拿大多，但比波兰少？显示姓名和人口。“

是我干的

SELECT name FROM world
  WHERE population >
     (SELECT population FROM world
      WHERE name='Canada')
  WHERE population < 
     (SELECT population FROM world
     WHERE name='Poland')

Answer 1

尝试以下操作，将第二个where替换为and。

SELECT name FROM world
  WHERE population >
     (SELECT population FROM world
      WHERE name='Canada')
  and population < 
     (SELECT population FROM world
     WHERE name='Poland')

Answer 2

你可以在..。

SELECT name FROM world
  WHERE population BETWEEN
     (SELECT population FROM world
      WHERE name='Canada')
  and 
     (SELECT population FROM world
     WHERE name='Poland')