GHG_Emission_5.D.1

SELECT 
    v.variable_uid,
    v.navigation,
    v.measure,
    v.gas,
    v.unit,
    g.submission_version,
    g.country_code,
    g.country,
    g.inventory_year,
    g.value
FROM [GHG_Inventory].[latest].[ghg_value] AS g
JOIN [GHG_Inventory].[latest].[ghg_variable] AS v
    ON g.variable_uid = v.variable_uid
WHERE g.variable_uid = '0fe78dc2-6f44-480c-8456-64fc5d7fb072'
  AND g.inventory_year >= 2010
ORDER BY country_code, inventory_year