Country profile - protected species - Conservation Status by Taxa

SELECT * FROM (SELECT countryCode as iso2,
Species_Group as species_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_Species_Group
WHERE Species_Group NOT IN ('Total')) a