image.png
Germany (population 80 million) has the largest population of the countries in Europe. Austria (population 8.5 million) has 11% of the population of 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(( 100* population /
(select population from world where name = 'Germany')),0),'%')
as pecent from world where continent='Europe';
网友评论