cnct_clim_ghgview_4g_co2_eu27

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