In the World population practice, in question 4, I did this:
//with uni as (select * from countries
left join population_years
on countries.id = population_years.country_id)
select sum (population) from uni
where continent = ‘Oceania’ and year = 2005;//
And the codecademy answer is this:
//SELECT SUM(population) FROM population_years
INNER JOIN countries ON
countries.id = population_years.country_id
WHERE year = 2005
AND continent = ‘Oceania’;//
And the answer was correct.
So, what is the computing difference?