cnct_countryfact_natura2000_biodiv_n2k_inside_outside

SELECT 
  NUTS_CODE,
  country,
  group_type,
  group_value/(NULLIf(1000000,0)) as group_value,
  total,
  units,
  forestN2K_percentage AS value
  FROM [FISE].[latest].[v_countryfact_natura2000_biodiv_N2K_inside_outside]
  WHERE year=2018 and group_type='Inside'
  
UNION   
  
SELECT 
  NUTS_CODE,
  country,
  group_type,
  group_value/(NULLIf(1000000,0)) as group_value,
  total,
  units,
  forest_percentage as value
  FROM [FISE].[latest].[v_countryfact_natura2000_biodiv_N2K_inside_outside]
  WHERE year=2018 and group_type='Outside'