Country profile - protected habitats - Conservation status by group

SELECT * FROM (SELECT countryCode as iso2,
Habitats_Group as habitat_group,
Percentage_Good as percentage_good,
Percentage_Poor as percentage_poor,
Percentage_Bad as percentage_bad,
Percentage_Unknown as percentage_unknown
FROM BISE.latest.Conservation_status_Habitats_Group
WHERE Habitats_Group NOT IN ('Total')) a