Protected species endemic counter

select	country_code as iso2,
	count(*) as number_endemic_unique_species
from	BISE.latest.Country_Endemic_Species_Unique_to_Country
group by country_code