SELECT practicing queryies on SQLzoo.net

SQLzoo - SELECT within SELECT tutorial

1. 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:

SELECT name,
    CONCAT(ROUND(100*(population / (SELECT population FROM world WHERE name='Germany')),0),'%')
FROM world
WHERE continent = 'Europe'

this one rounds to 0 decimal places but prints like 10 zeros when MsSQL selected, MySQL reults are as expected, nicely rounded no decimals. CONCAT can be replaced by || or + on some SQL versions.

2. Which countries have a GDP greater than every country in Europe? [Give the name only.] (Some countries may have NULL gdp values)

SELECT name
FROM world
WHERE gdp > ALL(SELECT gdp
                   FROM world   
                  WHERE gdp > 0
                    AND continent = 'Europe') 

EZ