[SQL] SQL query does not return expected result

I am running the examples to be found here: https://sqlzoo.net/wiki/SELECT_within_SELECT_Tutorial

I am given a table named world:





I would expect this:



Why do I get this result, and how can I correct my SQL query?

Continue reading...