Conservation status bad by Habitats Directive

select	country_code,
	assessment,
	habitats_assessment,
	total_species,
	percentage_assessment,
	assessment_order
from	EUNIS.v1.BISE_Country_Conservation_Status_Habitats_Habitats_Directive
where assessment = 'Bad'
order by assessment_order