cnct_clim_GHG_EEA_4A_Emissions_EU27

SELECT  [country]
      ,[NUTS_CODE]
      ,[gas]
      ,[emissions_units]
      ,[year]
      ,[sector_name]
      ,ABS([emissions]/1000000) as emissions
      ,[emissions_per_capita]
      ,[emissions_gdp]
  FROM [FISE].[LATEST].[v_clim_GHG_Emissions_4AH_EU27_All_GHG]
	where sector_name = '4.A - Forest Land' and NUTS_CODE = 'EU27' and year = 2021