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_natda_sites as 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