CNCT Forest Area Change EU28

CNCT Forest Area Change EU28

(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'CLC' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[CLC] 
where nuts_level=0 and NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
UNION ALL
(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'HRL' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[HRL] 
where nuts_level=0 and NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
UNION ALL
(select YEAR, sum(FORES_AREA) as SUM_FORES_AREA, 'NFI' as SOURCE, YEAR as SORT_HACK from [FISE].[latest].[nfi_forest_area] 
where NUTS_CODE in ('AT','BE','BG','HR','CY','CZ','DK','EE','FI','FR','DE','EL','HU','IE','IT','LV','LT','LU','MT','NL','PL','PT','RO','SK','SI','ES','SE','UK')
group by YEAR)
order by 1