cnct_countryfact_clc_share_forest_area_deforested

SELECT LAND.country AS Country,
  LAND.NUTS_CODE,
  LAND.year as land_cover_year,
  AREA.year as forest_area_change_year,
  LAND.fores_area_311_312_313_324 AS forest_area,
  AREA.deforestation *1000 as deforestation,
  ((AREA.deforestation *1000)*100)/NULLIF(LAND.fores_area_311_312_313_324, 0) as perc_deforested
FROM [FISE].[latest].[v_multi_clc_forest_and_land_cover] AS LAND
INNER JOIN FISE.latest.v_vita_gfra_forest_area_change AS AREA ON LAND.NUTS_CODE=AREA.NUTS_CODE
where LAND.year = 2000