sql如何查找各门课程成绩都大于‘王林’所得课程成绩的同学的姓名

select a.name from table_name a,(select grade1,grade2,grade3..(有多少科目啊) from table_name where name='王林') b, where a.grade1>b.grade1 and a.grade2>b.grade2,.....