cnct_vita_GFRA_forest_area_change_deforestation

Select  [NUTS_CODE]
      ,[Country_name]
      ,[EU28]
      ,[EU27]
      ,[EEA38]
      ,[EEA39]
      ,[1990_2000] AS value
      ,'1990-2000' as year
      ,0 as year_sort
      ,'1000 Ha/year' as [Unit]
from [FISE].[latest].[v_vita_GFRA_forest_area_change_deforestation]

UNION 

Select  [NUTS_CODE]
      ,[Country_name]
      ,[EU28]
      ,[EU27]
      ,[EEA38]
      ,[EEA39]
      ,[2000_2010] AS value
      ,'2000-2010' as year
      ,1 as year_sort
      ,'1000 Ha/year' as [Unit]
from [FISE].[latest].[v_vita_GFRA_forest_area_change_deforestation]

UNION 

Select  [NUTS_CODE]
      ,[Country_name]
      ,[EU28]
      ,[EU27]
      ,[EEA38]
      ,[EEA39]
      ,[2010_2015] as value
      ,'2010-2015' as year
      ,2 as year_sort
      ,'1000 Ha/year' as [Unit]
from [FISE].[latest].[v_vita_GFRA_forest_area_change_deforestation]

UNION 

Select  [NUTS_CODE]
      ,[Country_name]
      ,[EU28]
      ,[EU27]
      ,[EEA38]
      ,[EEA39]
      ,[2015_2020] AS value
      ,'2015-2020' as year
      ,3 as year_sort
      ,'1000 Ha/year' as [Unit]
from [FISE].[latest].[v_vita_GFRA_forest_area_change_deforestation]
No data