SELECT
entity,
emissions_kg,
emissions_1000kcal,
emissions_100g_protein,
bananas_index_kg,
bananas_index_1000_kcalories,
bananas_index_100g_protein
FROM (
SELECT
entity,
emissions_kg,
emissions_1000kcal,
emissions_100g_protein,
bananas_index_kg,
bananas_index_1000_kcalories,
bananas_index_100g_protein,
-- Calculate an overall efficiency score (lower is better)
(emissions_kg + emissions_1000kcal) AS total_emissions
FROM @kaggle.joebeachcapital_banana_index.bananaindex
) AS subquery
ORDER BY total_emissions DESC -- Sort by total emissions in descending order (highest first)
LIMIT 10;