SELECT country, activeduty AS "active duty", activeduty/pop2022 AS "per 1000"
FROM @kaggle.durgeshrao9993_top_greatest_armies_of_the_world.world_army_dataset
ORDER BY activeduty DESC
LIMIT 5SELECT country, activeduty AS "active duty", activeduty/pop2022 AS "per 1000"
FROM @kaggle.durgeshrao9993_top_greatest_armies_of_the_world.world_army_dataset
ORDER BY activeduty DESC
LIMIT 5Anyone who has the link will be able to view this.