Conservation Status of habitats Habitats Directive DONUT

SELECT *
FROM (
    SELECT countryCode as iso2, 'Good' label,
    Percentage_assessment_Good value, 1 as o
    FROM BISE.latest.Conservation_Status_Habitats_Art17
    UNION
    SELECT countryCode as iso2, 'Poor' label,
    Percentage_assessment_Poor value, 2 as o
    FROM BISE.latest.Conservation_Status_Habitats_Art17
    UNION
    SELECT countryCode as iso2, 'Bad' label,
    Percentage_assessment_Bad value, 3 as o
    FROM BISE.latest.Conservation_Status_Habitats_Art17
    UNION
    SELECT countryCode as iso2, 'Unknown' label,
    Percentage_assessment_Unknown value, 4 as o
    FROM BISE.latest.Conservation_Status_Habitats_Art17
) as Conservation_Status_Habitats_Art17 order by o

No data