Typology of protection - LAND DOUNT

SELECT *
FROM (
    SELECT countryCode as iso2, 'Both' label,
    Percentage_Terrestrial_Overlap value
    FROM BISE.latest.ProtectedAreas_Stats_Type_Percentage
    UNION ALL
    SELECT countryCode as iso2, 'Natura 2000 sites' label,
    Percentage_Terrestrial_N2K_only value
    FROM BISE.latest.ProtectedAreas_Stats_Type_Percentage
    UNION ALL
    SELECT countryCode as iso2, 'National laws' label,
    Percentage_Terrestrial_CDDA_only value
    FROM BISE.latest.ProtectedAreas_Stats_Type_Percentage
) as ProtectedAreas_Stats_Type_Percentage
order by label

No data