cnct_countryfact_GHG_clim_emissions_sink_forest_country

Select [NUTS_CODE]
            ,country
            ,[year]
            ,[gas]
            ,sum([value]/1000000) as value
            ,'Mt CO2 equivalent' as [unit]
            ,[notation] from [FISE].[latest].[v_countryfact_GHG_clim_All_Emissions_countries]
        where (sector_code = '4.A' or sector_code= '4.G') and gas = 'All greenhouse gases - (CO2 equivalent)' and year=2020
        group by [NUTS_CODE],country,[year],[gas], [unit], [notation]