cnct_countryfact_eurostat_bioeco_wood_for_remov_pie_chart

SELECT 
    NUTS_CODE,
    bark,
    country,
    units,
    ROUND((value/1000),2) AS value,
    wood_product,
    percentage_value,
    year
FROM [FISE].[latest].[v_countryfact_eurostat_bioeco_wood_for_remov]
WHERE 

        -- COUNTRIES WITH FIX DATE
        (NUTS_CODE = 'FR'   AND year = 2022) OR
        (NUTS_CODE = 'IS'   AND year = 2022) OR
        (NUTS_CODE = 'EU27' AND year = 2021) OR
        (NUTS_CODE = 'NL'   AND year = 2021) OR
        (NUTS_CODE = 'BE'   AND year = 2020) OR
        (NUTS_CODE = 'DK'   AND year = 2016) OR
        (NUTS_CODE = 'IE'   AND year = 2017) OR
        (NUTS_CODE = 'EL'   AND year = 2017)
    OR
        -- REST
        (NUTS_CODE NOT IN ('BE','DK','IE','FR','IS','EU27','NL','EL')
         AND year = 2023)