Link: Learn data science with Python and R projects
My Code:
select name
from facts
where population > (select avg(population) from facts)
and area < (select avg(area) from facts );
What I expected to happen:
Shouldn’t the above code fetch more rows? I checked the Solution and found
that there were more countries
What actually happened:
I just need some explanation as to why my code fetched lesser number of rows even though I did not filter anything