fix it to display total_population instead
-this gives the same results
although this gives the same results, it is more error-proof IMO, reason being
suggestion given in the issue's description assume that population for a country remains the same (only has 1 distinct value) throughout. However, this might no be true
my approach takes that into calculation and uses the population of the latest date where the population data is not NULL
this ensures that if there's multiple population values for a single country, it will be taken into consideration too
closes https://github.com/adriangohjw/bc2402-designing-developing-databases/issues/5
total_populationinstead -this gives the same resultspopulationdata is not NULL