请参阅以下sql
select [学号],[姓名] from [学生信息表] where exists(
(select [学号] from [成绩表] where [课程]<60
group by [学号] having count([课程]) >=3 ) as t1
where [t1].[学号] = [学生信息表].[学号]
)
有疑问及时沟通
一般情况下，这样写就可以了
请采纳！
请参阅以下sql
select [学号],[姓名] from [学生信息表] where exists(
(select [学号] from [成绩表] where [课程]<60
group by [学号] having count([课程]) >=3 ) as t1
where [t1].[学号] = [学生信息表].[学号]
)
有疑问及时沟通
一般情况下，这样写就可以了
请采纳！
