1SELECT 
2    entity,
3    emissions_kg,
4    emissions_1000kcal,
5    emissions_100g_protein,
6    bananas_index_kg,
7    bananas_index_1000_kcalories,
8    bananas_index_100g_protein
9FROM (
10    SELECT 
11        entity,
12        emissions_kg,
13        emissions_1000kcal,
14        emissions_100g_protein,
15        bananas_index_kg,
16        bananas_index_1000_kcalories,
17        bananas_index_100g_protein,
18        -- Calculate an overall efficiency score (lower is better)
19        (emissions_kg + emissions_1000kcal) AS total_emissions
20    FROM @kaggle.joebeachcapital_banana_index.bananaindex
21) AS subquery
22ORDER BY total_emissions ASC  -- Sort by total emissions in ascending order (lowest first)
23LIMIT 10;