Conservation status bad species

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