The following SQL statement is an example of a Type II nested query:
SELECT StdSSN,StdFirstName,StdLastName,StdMajor
FROM Student
WHERE EXISTS
(SELECT StdSSN FROM Enrollment
WHERE Student.StdSSN = Enrollment.StdSSN
AND EnrGrade 3.5)

Question

The following SQL statement is an example of a Type II nested query:
SELECT StdSSN,StdFirstName,StdLastName,StdMajor
FROM Student
WHERE EXISTS
(SELECT StdSSN FROM Enrollment
WHERE Student.StdSSN = Enrollment.StdSSN
AND EnrGrade > 3.5)

Quizplus · Accepted Answer

This is a Type II nested query because the outer query returns information from the Student table, and the inner query checks for the existence of records in the Enrollment table for each student that meets the grade condition.

The Following SQL Statement Is an Example of a Type