cnct_countryfact_ghg_clim_all_emissions_countries

cnct_countryfact_ghg_clim_all_emissions_countries

Select country,
	NUTS_CODE,
	gas,
	notation,
	sector_code,
	sector_name,
	unit,
	value/1000000 as value,
	year from [FISE].[v1].[v_countryfact_GHG_clim_all_emissions_countries]
 where sector_name = 'Total emissions (UNFCCC)' and gas = 'All greenhouse gases - (CO2 equivalent)'
order by year DESC