cnct_clim_GHG_EEA_TotalEmissions_EU27

Select  [country]
      --,[NUTS_CODE]
      ,[gas]
      ,[emissions_units]
      ,[year]
      ,[sector_name]
      ,[emissions]/1000000 As emissions
      ,[emissions_per_capita]
      ,[emissions_gdp] from [FISE].[latest].[v_clim_GHG_Emissions_4AH_EU27_All_GHG]
Where  Year = 2021 AND sector_name LIKE '%Total net emissions with international aviation (E%'