select * from RIVERS where river='CR' order by mile desc

River	Mile	City
#river#	#Mile#	#City#