cnct_countryfact_faostat_bioeco_wood_for_remov_pie_chart

SELECT 
    Country,
    NUTS_CODE,
    Unit,
    Year,
    value / 1000000 AS value,
    wood_product
FROM [FISE].[latest].[v_countryfact_faostat_bioeco_wood_for_remov]
WHERE Year = (
    SELECT MAX(Year) 
    FROM [FISE].[latest].[v_countryfact_faostat_bioeco_wood_for_remov]
) and value != 0