Countries protected areas statistics

select country_code as iso2,
	country_name,
	number_natura2000_sites,
	number_natura2000_sites_birds_directive,
	number_natura2000_sites_habitats_directive,
	number_cdda_sites,
	number_total_sites,
	number_species,
	number_habitats,
	ROUND(number_natura2000_sites*100.0/number_total_sites, 2) percent_n20004
from	BISE.latest.Country_Information