select studid from transcript where studid in ( --选了这两门课的学生学号 select studid from transcript where crscode ='cs305' or crscode = 'mgt123' group by studid having count(*)=2 ) group by studid having count(*)=2--仅仅选修了这两门课程的学生