First page Back Continue Last page Image

Nested Queries

SELECT s.studentid, s.name, g.total_grade

FROM student s, grade g

WHERE s.studentid = g.studentid AND g.total_grade >

(SELECT total_grade

FROM grade

WHERE studentid = '41659022');