Total numbers of EU 27 Protected Areas

SELECT REPLACE(FORMAT(SUM(number_total_sites),'#,0'),',',' ') number_total_sites_eu27 FROM BISE.latest.Country_Information
where country_code not in ('BA', 'CH', 'MK', 'NO', 'TR', 'XK', 'ME', 'UK')