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 ASC  -- Sort by total emissions in ascending order (lowest first)
LIMIT 10;