select
		name,
		score,
		case
			when score >= 80 then 'A'
			when score >= 60 then 'B'
			else 'C'
		end as rank
	from student
	order by gnum, cnum, num
	limit 10
;