Protected species endemic counter

select	country_code,
	count(*) as number_endemic_unique_species
from	EUNIS.v1.BISE_Country_Endemic_Species_Unique_to_Country
group by country_code