1SELECT 
2  passport_color, 
3  SUM(deaths.cumulative_deaths_in_armed_conflicts) deaths, 
4  SUM(population.population_2022) population, 
5  AVG(deaths.cumulative_deaths_in_armed_conflicts / population.population_2022) * 1000 deaths_per_1000
6FROM
7  @kaggle.willianoliveiragibin_millions_have_died.cumulative_deaths_in_armed_conflicts_new deaths
8INNER JOIN @jsoares.passport_colours.passports passports 
9  ON deaths.country = passports.country
10INNER JOIN @kaggle.ahmadjalalmasood123_world_population_dataset.world_population_2022 population 
11  ON deaths.country = population.country_or_dependency
12GROUP BY passport_color
13ORDER BY 4 DESC