worldpop population density per country 2020

worldpop_density.sql

SELECT
  country_name, 
  COUNT(1) AS hectares, 
  SUM(population) AS total_pop, 
  SUM(population)/COUNT(1) AS pop_per_hectare
FROM
  `bigquery-public-data.geo_worldpop.WorldPop_GP_100m` AS pop
  ,`bigquery-public-data.country_codes.country_codes` AS codes
WHERE TRUE
  AND pop.country_code = codes.alpha_3_code
  AND pop.population >= 0
  AND pop.year = 2020
GROUP BY country_name
ORDER BY pop_per_hectare DESC