cnct_clim_ghgview_4g_co2_eu27

SELECT
  NUTS_CODE,
  year,
  --sector_code,
  sector_name,
  gas,
  emissions AS HWP,
  unit
FROM [FISE].[latest].[v_countryfact_GHG_clim_LULUCF_emissions]  
where sector_name LIKE '%4.G%' and gas='All greenhouse gases - (CO2 equivalent)' 
ORDER BY NUTS_CODE,year