cnct_biodiv_clc_classification_pie_chart

SELECT 
  'Broadleaved' AS class_type,
  broadleaved AS value,
  broadleaved_percentage AS percentage,
  'ha' AS units
  FROM [FISE].[latest].[v_biodiv_CLC_classification]
  
UNION ALL  
  
SELECT 
  'Coniferous' AS class_type,
  coniferous AS value,
  coniferous_percentage AS percentage,
  'ha' AS units
  FROM [FISE].[latest].[v_biodiv_CLC_classification]
  
UNION ALL  
  
SELECT 
  'Mixed forest' AS class_type,
  mixed AS value,
  mixed_percentage AS percentage,
  'ha' AS units
  FROM [FISE].[latest].[v_biodiv_CLC_classification]
  
UNION ALL   
  
SELECT 
  'Transitional woodland and shrubs' AS class_type,
  transitional_woodland AS value,
  transitional_woodland_percentage AS percentage,
  'ha' AS units
  FROM [FISE].[latest].[v_biodiv_CLC_classification]