Protected species composition

SELECT * FROM (SELECT  countryCode as iso2,
'Amphibians' as species_group,
Percentage_Amphibians as group_percentage,
Count_Amphibians as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Arthropods' as species_group,
Percentage_Arthropods as group_percentage,
Count_Arthropods as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Fishes' as species_group,
Percentage_Fish as group_percentage,
Count_Fish as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Mammals' as species_group,
Percentage_Mammals as group_percentage,
Count_Mammals as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Molluscs' as species_group,
Percentage_Molluscs as group_percentage,
Count_Molluscs as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Non vascular plants' as species_group,
Percentage_Non_vascular_plants as group_percentage,
Count_Non_vascular_plants as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Other invertebrates' as species_group,
Percentage_Other_invertebrates as group_percentage,
Count_Other_invertebrates as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Reptiles' as species_group,
Percentage_Reptiles as group_percentage,
Count_Reptiles as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Vascular plants' as species_group,
Percentage_Vascular_plants as group_percentage,
Count_Vascular_plants as number_species
FROM [BISE].[latest].[Number_Composition_Species]
UNION ALL
SELECT  countryCode as iso2,
'Birds' as species_group,
Percentage_Birds as group_percentage,
Count_Birds as number_species
FROM [BISE].[latest].[Number_Composition_Species]
) a
WHERE number_species > 0 
order by group_percentage desc