jisaw/sqlzoo-solutions

SELECT with SELECT Exercise 5 is incorrect

Etabat opened this issue · 0 comments

I found that the solution posted as one today is incorrect.
The following worked for me:
SELECT name,
CONCAT(ROUND(
(population*100) /
(SELECT population FROM world WHERE name = 'Germany'), 0
), '%')
FROM world
WHERE continent = 'Europe'