我对嵌套查询也不熟悉，不过下面的代码是测试通过的：
insert into GRADE select 'st' as StudentName,SubjectName from SUBJECT where MajorID =(select top 1 MajorID from MAJOR where MajorName ='m2')
