計算機教材-一個計算機思維導論的題，求大神解答

一個計算機思維導論的題，求大神解答

求解答！！！

最佳回答：

 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'