cnct_countryfact_GHG_clim_LULUCF_emissions

Select  [country] 
      ,[NUTS_CODE] as [NUTS_CODE]
      ,[gas]
      ,[unit]
      ,[year]
      ,[sector_name]
      ,[emissions]/1000000 as [emissions] from [FISE].[latest].[v_countryfact_GHG_clim_LULUCF_emissions]
order by [Year] ASC