EUNIS revised habitat type Tree View

SELECT habitat_type_tree FROM [EUNIS].[latest].[Habitat_Information] h1 WHERE habitat_category = 'EUNISrev' 
order by habitat_type_tree