SELECT within SELECT Tutorial @ http://sqlzoo.net
1. SELECT name FROM bbc WHERE population > (SELECT population FROM bbc WHERE name='Russia') 2. SELECT name, region FROM bbc WHERE region IN (SELECT region FROM bbc WHERE name='India' OR name='Iran') 2. (A better answer) SELECT name, region FROM bbc WHERE region IN (SELECT region FROM bbc WHERE name IN ('India','Iran')) 3. SELECT name FROM bbc WHERE (gdp/population) > (SELECT (gdp/population) FROM bbc WHERE name='United Kingdom' ) AND region='Europe' 4. SELECT name FROM bbc WHERE Population > (SELECT population FROM bbc WHERE name='Canada') AND Population < (SELECT population FROM bbc WHERE name='Algeria') 5. SELECT name FROM bbc WHERE name NOT IN (SELECT name FROM bbc WHERE region='Europe') AND gdp > (SELECT max(gdp) FROM bbc WHERE region='Europe') 5. (A better answer) SELECT name FROM bbc WHERE gdp > ALL (SELECT gdp FROM bbc WHERE region=’Europe’)
