cnct_clim_ghg_emissions_4ah_eu27_all_ghg

Select [country]
      ,[NUTS_CODE]
      ,[gas]
      ,[emissions_units]
      ,[year]
      ,[sector_name]
      ,[emissions]/1000000 As emissions
      ,[emissions_per_capita]
      ,[emissions_gdp]
      ,[emissions_per_capita_units]
      ,[emissions_gdp_units] from [FISE].[v1r1].[v_clim_GHG_Emissions_4AH_EU27_All_GHG]
      Where country = 'EU27' AND Year = 2019 AND sector_name = 'Total emissions (UNFCCC)'