Natura 2000 Sites

select site_code,
    CONCAT_WS('/', lower(site_type), site_code) as site_code_type,
	site_name,
	country_name,
	area_ha,
	number_protected_habitat_types,
	number_protected_species,
	site_type
from	BISE.latest.Site_Information
where site_type like 'Natura2000'
order by country_name