cnct_countryfact_GHG_clim_emissions_sink_forest_country

cnct_countryfact_GHG_clim_emissions_sink_forest_country

Select [NUTS_CODE]
      ,country
      ,[year]
      ,[sector_code]
      ,[sector_name]
      ,[gas]
      ,ABS([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' and gas = 'All greenhouse gases - (CO2 equivalent)'
	ORDER BY year DESC