Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT country.name AS "Country", city.name AS "City", city.population AS "Population"
- FROM city JOIN country ON city.countrycode = country.code WHERE city.population = (SELECT min(population) FROM city WHERE city.countrycode = country.code) ORDER BY country
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement