use student_class
select student.*
from student,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and  cno='2' and grade>any
(
 select grade 
from sc ,student
where cno='2'and
student.sclass=sc.sclass and student.sno=sc.sno

)