SQLZ00答案3:SELECT_within_SELECT_Tutorial/zh

• SELECT_within_SELECT_Tutorial/zh

SELECT name FROM world
  WHERE population >
(select population from world where name='Russia')

select name 
from world
where continent='Europe' and gdp/population>
(select gdp/population from world where name='United Kingdom')  

select name,continent
from world
where continent in 
(select continent from world where name in('Argentina','Australia')
)
order by name

select name,population
from world
where population >
(select population from world where name='Canada')
and  population <
(select population from world where name='Poland')

5. hard

select name,concat(round(population/(select population from world where name='Germany')*100,0),'%') 
from world 
where continent='Europe'

select name from world 
where gdp>all(
	select gdp 
	from world 
	where continent='Europe' and gdp>0)

select continent,name,area 
from world x
where area>=all(
	select  area from world y
	where x.continent=y.continent
	and area>0)

select continent,name from world x 
where name<=all(
	select name from world y where x.continent=y.continent order by continent  )

select name,continent,population from world x
WHERE 25000000 >=ALL(select population from world y where x.continent=y.continent and population>0)

select name,continent from world x where x.population/3>=all (select population from world y where x.continent=y.continent and population>0 and x.name<>y.name)