select * from student
	where (gnum, cnum) = any(select gnum, num from class where charge in ('����','�X�c'))
	order by gnum, cnum, num
;