SELECT student.sname,student.sage,student.ssex,course.cname,sc.score
from sc , student ,course
WHERE sc.sid IN
(
SELECT a.sid from
(SELECT * from sc t WHERE t.cid='01') a,
(SELECT * from sc t WHERE t.cid='02') b
WHERE a.sid=b.sid AND a.score>b.score
)
AND sc.sid=student.sid(+) AND sc.cid=course.cid(+);