cnct_countryfact_ghg_clim_forest_land_removals

Select   [NUTS_CODE]
,[country]
      ,[year]
      ,[sector_code]
      ,[sector_name]
      ,[gas]
      ,[value]/1000000 as value
      ,[unit]
      ,[notation] from [FISE].[v1].[v_countryfact_GHG_clim_All_Emissions_countries]
where sector_code = '4.A' AND gas = 'All greenhouse gases - (CO2 equivalent)'
order by year