Advertisement
Guest User

Untitled

a guest
Mar 20th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT name, continent, population
  2. FROM world x
  3. WHERE (
  4. SELECT COUNT(name)
  5. FROM world y
  6. WHERE y.population <= 25000000
  7. AND x.continent = y.continent
  8. ) = (
  9. SELECT COUNT(name)
  10. FROM world z
  11. WHERE x.continent = z.continent
  12. )
  13. ORDER BY continent, population DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement