Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name, continent, population
- FROM world x
- WHERE (
- SELECT COUNT(name)
- FROM world y
- WHERE y.population <= 25000000
- AND x.continent = y.continent
- ) = (
- SELECT COUNT(name)
- FROM world z
- WHERE x.continent = z.continent
- )
- ORDER BY continent, population DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement