|
1.select distinct subject.name from class,student_class,student_subject,subject where class.id = student_class.classid and student_class.student=student_subject.studentid andstudent_subject.subjectid = subject.ID and class.name = '1class'2.select student.* from student,student_subject,subject where student_subject.studentid=student.id and student_subject.subjectid=subject.id and subject.name='腔戚慎1subject'3.select avg(score) fromstudent_subject,subject where student_subject.subjectid=subject.id and subject.name='1subject'4.select max(score) fromstudent_subject,subject where student_subject.subjectid=subject.id and subject.name='伍敬仔者1subject'5.select min(score) fromstudent_subject,subject where student_subject.subjectid=subject.id and subject.name='1subject' |
