SQL_Zoo
SQL_Zoo copied to clipboard
wrong answer
https://github.com/Chenzilla/SQL_Zoo/blob/07e356b1f83ccfa796cbe6e1c033a42cf7b37a85/4_soutions.sql#L10
correct answer is
SELECT name FROM world
WHERE continent='Europe' AND gdp/population > (SELECT gdp/population FROM world WHERE name='United Kingdom')
It is actually updated to:
Which country has a population that is more than United Kingdom but less than Germany? Show the name and the population.