Baselight
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;  
entityemissions_kgemissions_1000kcalemissions_100g_proteinbananas_index_kgbananas_index_1000_kcaloriesbananas_index_100g_protein
Beef steak129.74771568.095953564.190391148.563323877.752629488.3128054
Beef mince95.034572347.336598153.1110261108.816189554.04939336.878001796
Beef meatballs70.787474231.338691335.620428181.0528528735.782825974.612928547
Beef burger53.976370821.905134228.806285761.803855725.011497683.730481208
Cottage cheese25.278503129.346968322.337566128.9443127633.508657052.892766927
Prawns20.911282826.329289713.121884623.9437717930.063041951.699314671
Lamb (leg)30.740947315.182483216.628528635.1989035717.335508652.153433251
Lamb chops30.901992911.828167717.18850135.383303513.505518222.225950983
Lamb burgers26.928288710.815350715.773419730.8333451212.349073812.042694653
Raspberries8.37097224.614977960.83917079.58490424428.105623877.878814553

Share link

Anyone who has the link will be able to view this.