-- 查询⾄少有⼀门课与学号为"01"的同学所学相同的同学的信息 ** group_concat函数将学⽣所学课程转化为字符串，⽐较字符串 select * from student where s_id in(select distinct b.s_id from score b where b.c_id in (select c_id from score where s_id ='01'))-- 查询和"01"号的...