Habitat_Redlist_Status_occurrence_ext

SELECT * FROM (SELECT
    habitat_unique_id,
    'EU28' AS region,
    occurrence_ext_EU28_EOO AS extent_of_occurrence_EOO,
    occurrence_ext_EU28_AOO AS area_of_occupancy_AOO,
    occurrence_ext_EU28_area_km2 AS current_estimated_total_area,
    occurrence_ext_EU28_comment AS comment
FROM EUNIS.latest.Habitat_Redlist_Status
UNION ALL
SELECT
    habitat_unique_id,
    'EU28+' AS region,
    occurrence_ext_EU28PLUS_EOO AS extent_of_occurrence_EOO,
    occurrence_ext_EU28PLUS_AOO AS area_of_occupancy_AOO,
    occurrence_ext_EU28PLUS_area_km2 AS current_estimated_total_area,
    occurrence_ext_EU28PLUS_comment AS comment
FROM EUNIS.latest.Habitat_Redlist_Status) as a