select a.* 
	from (select s.* ,group_concat(c_name) find
		from score s
		group by stu_id) a
	where find like '%计算机%'
		and find like '%英语%';