Conservation Status of species Habitats Directive DONUT

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

No data