SQL_Zoo

SQL_Zoo copied to clipboard

wrong answer

1

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') ```

OseungKwon

Solution for 14. "Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last", is updated.

khodsadul

A solution that can be easily understood for question 9

1

select y.name, y.continent, y.population from world as y Join (select continent,max(population) from world group by continent having max(population)

satishjasthi

answer 11, 12, 13 are incorrect. can you check? solution 6

1

michaelzeng25

Solution to the second problem does not limit countries in Europe, hence I added condition to reflect it

grayrhinos

EdenK

gabycasper007

Added 'Barack Obama' to Show all details of the presidential winners

shaijut