Conservation status bad by Habitats Directive

select	country_code as iso2,
	assessment,
	habitats_assessment,
	total_species,
	percentage_assessment,
	assessment_order
from	BISE.latest.Country_Conservation_Status_Habitats_Habitats_Directive
where assessment = 'Bad'
order by assessment_order