SHARE
TWEET

Untitled

a guest Mar 20th, 2017 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top