SELECT name FROM world
WHERE population >
(SELECT population FROM world
WHERE name='Russia')
SELECT name FROM world
WHERE continent = 'Europe'
AND gdp/population >
(SELECT gdp/population FROM world
WHERE name = 'United Kingdom')
SELECT name, continent FROM world
WHERE continent IN
(SELECT continent FROM world WHERE name IN ('Argentina','Australia'))
ORDER BY name
SELECT name, population FROM world
WHERE population >
(SELECT population FROM world WHERE name = 'United Kingdom')
AND population <
(SELECT population FROM world WHERE name = 'Germany')
Show the name and the population of each country in Europe. Show the population as a percentage of the population of Germany.
The format should be Name, Percentage for example:
name | percentage |
---|---|
Albania | 3% |
Andorra | 0% |
Austria | 11% |
... ...
SELECT name , CONCAT(ROUND((population*100)/(SELECT population FROM world WHERE name = 'Germany'),0),'%') FROM world
WHERE continent = 'Europe'