select count from stu a inner join sc b on acno=bcno inner join cou c on bsno=csno where college=汽车学院 groop by sname heving count 30;请告诉我语法上有什么问题请用中文回答

语法上的问题是 groop 应该为 group。正确的语法应该是：

select count() from stu a inner join sc b on a.cno=b.cno inner join cou c on b.sno=c.sno where college='汽车学院' group by sname having count() > 30;