求解答!!!
select s1.sname as stud1,s2.sname as stud2 from student s1,student s2 where s1.score>s2.score and s1.subject = s2.subject and s1.subject = '001'
表结构呢,你要写第3题吗?问题都写不清楚