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