各ステータス中最も良いものを各々取得したい

select
	case max(st1)
		when 9 then 1
		when 8 then 6
		.
		.
		else 0
	end as st1,
	case max(st2)
		when 9 then 1
		when 8 then 6
		.
		.
		else 0
	end as st2,
	.
	.
	.
from
	(	select
			case st1
				when 1 then 9
				when 6 then 8
				when 2 then 7
				.
				.
				.
				else 0
			end as st1,
			case st2
				when 1 then 9
				when 6 then 8
				when 2 then 7
				.
				.
				.
				else 0
			end as st2,
			.
			.
			.
		from
			table) as table