Can anyone help me with the following:
Some countries have populations more than three times that of any of their neighbours (in the same region). Give the countries and regions.
select x.name, x.region from bbc x where x.population >all (select population*3 from bbc y where y.region = x.region)
syntax is correct but no records are returned (should return 3 rows)
Find each country that belongs to a region where all populations are less than 25000000. Show name, region and population.
select name, region, population from bbc where region not in (select distinct region from bbc where population >= 25000000)
I used "not in". Is there a way to use "in" ?