Habitat composition by group

select	country_code,
	habitat_group,
	number_habitats,
	group_percentage
from	EUNIS.v1.BISE_Country_Habitat_Group_Percentage
order by group_percentage desc