select couunt 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;请告诉我语法上有什么问题

1. "select couunt()" should be "select count()".
2. "groop by" should be "group by".
3. There seems to be a typo in "heving". It should be "having".
4. The query is missing a semicolon at the end.

Corrected query:

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;