cnct_nat_son_20_3_2

cnct_nat_son_20_3_2

Select  [habitat_group] as EUNIS_HabitatsGroups
      ,[habitat_group_with_total]
      ,[coverage_surface_area] as Average_Areas_Km2
      ,[coverage_surface_area_to_be_improved]
      ,[coverage_surface_area_unknown]
      ,[perc_coverage_surface_area_to_be_improved]
      ,[perc_coverage_surface_area_unknown]
      ,[good]
      ,[unknown]
      ,[poor]
      ,[bad]
      ,[total]
      ,[perc_good]
      ,[perc_unknown]
      ,[perc_poor]
      ,[perc_bad] from [FISE].[v1].[v_cnct_nat_son20_4_24] where [habitat_group] = 'Grasslands' 
      or [habitat_group] = 'Coastal habitats'
      or [habitat_group] = 'Sclerophyllous scrub'
      or [habitat_group] = 'Rocky habitats'
      or [habitat_group] = 'Forests'
      or [habitat_group] = 'Heath and scrub'
      or [habitat_group] = 'Freshwater habitats'
      or [habitat_group] = 'Bogs, mires and fens'
      or [habitat_group] = 'Dune habitats'