Question

Write SQL queries to answer the following question: A. Which students are enrolled in Database and Networking? (Hint: use SectionNo for each class, so that you can determine the answer from the Registration table by itself.)

I have attempted the code below, but am receiving an error under the first SELECT, showing error code 1064, (syntax error)

SELECT StudentName, StudentID FROM Student

WHERE StudentID =(select StudentID FROM Registration

WHERE (SectionNo=2714 OR SectionNo=2715)

GROUP BY StudentID

HAVING COUNT (*)>1;

Answer 1

Since you have not provided the db schema, i am providing the query by guessing the table and column names. Hence, the query might need some suggestions in order to run properly.

QUERY:

SELECT StudentName, StudentID FROM Student s JOIN Registration r ON s.StudentID = r.StudentID

WHERE r.SectionNo IN(2714, 2715);