cnct_biodiv_soef_4_1_1_forest_species

SELECT 
  NUTS_CODE,
  country,
  forest_area_1000ha,
  forest_area_1000ha/1000 AS forest_area_1Mha,
  number_species,
  CASE
    WHEN sorting=1 THEN '1'
	WHEN sorting=2 THEN '2-3'
	WHEN sorting=3 THEN '4-5'
	ELSE '6'
  END AS number_species_without_text,
  year,
  sorting
FROM FISE.latest.v_biodiv_soef_4_1_1_forest_species
WHERE year=2015 AND NUTS_CODE='EU27'