cnct_clim_GHG_EEA_TotalEmissions_countries

Select   [country_name]
      ,[country_code]
      ,max([gas])as gas
      ,'Mt CO2 equivalent' as unit
      ,[year]
      ,sum([emissions])/1000000 as emissions from [FISE].[v1].[v_clim_GHG_Emissions_4AH_EU27_All_GHG]
 group by year,[country_name],[country_code]