sql - Where is the error in my nested MySQL query?

Question

I am guessing there is a mistake in the nested query however I cannot seem to find it myself. Here is the query:

Select student.sid, name 
from student join exam on exam.sid = student.sid
where student.sid in (select *
                from course join exam on cid=courseid 
                group by exam.sid
                having sum(credits) >= 20)

Thank you in advance!

question from:https://stackoverflow.com/questions/65643332/where-is-the-error-in-my-nested-mysql-query

Answer 1

You can use the group by as follows:

select s.sid, s.name 
from student s 
Join exam e on s.sid = e.sid
Join course c on c.cid = e.courseid
group by s.sid, s.name
having sum(c.credits) >= 20