use student_class
select distinct  student.*
from student ,course,sc
where student.sclass=sc.sclass and student.sno=sc.sno
and student.sclass='2' and course.cpno='1' and course.cno=sc.cno