Given the following table structures:

Student$($sno$,$ sname, gpa$)$

Reg$($sno$,$ cno, grade$)$

Course$($cno$,$ cname, credits$)$

Which of the following SQL statements will find students who have registered for more than $10$ credit hours?

SELECT s$.$sno, s$.$sname

FROM Student s$,$ Reg $r,$ Course c

WHERE s$.$sno $=$ r$.$sno AND c$.$cno $=$ r$.$cno

HAVING SUM$($c$.$credits$)>10$

SELECT s$.$sno, s$.$sname

FROM Student s$,$ Reg $r,$ Course c

WHERE s$.$sno $=$ r$.$sno AND c$.$cno $=$ r$.$cno

HAVING COUNT$($c$.$credits$)>10$

SELECT s$.$sno, s$.$sname

FROM Student s$,$ Reg r$,$ Course c

WHERE s$.$sno $=$ r$.$sno AND c$.$cno $=$ r$.$cno

AND count$($c$.$credits$)>10$

None of the others will work

SELECT s$.$sno, s$.$sname

FROM Student s$,$ Reg r$,$ Course c

WHERE s$.$sno $=$ r$.$sno AND c$.$cno $=$ r$.$cno

AND SUM$($c$.$credits$)>10$