Natura 2000 Species - Protection statistics

select top 1 ltrim(str(id_eunis,10)) as id_eunis,
(select count(*) y from EUNIS.v1.BISE_Species_Legal_Status 
where id_eunis = ls.id_eunis and legal_instrument = 'EU Habitats Directive') is_habitats,
(select count(*) y from EUNIS.v1.BISE_Species_Legal_Status 
where id_eunis = ls.id_eunis and legal_instrument != 'EU Habitats Directive') count_without_habitats
from EUNIS.v1.BISE_Species_Legal_Status as ls