求大佬帮忙做题

[qwer_12341234]

内容如图～蟹蟹蟹蟹蟹蟹

[qwer_12341234]

大佬们嫌这太简单嘛

[lhdz_bj]

大佬们希望你自己能勤快点。。。

[qwer_12341234]

引用 2 楼 lhdz_bj 的回复：

大佬们希望你自己能勤快点。。。

知识储备不足，做不出来

[zhanglei_521]

第三题 select subject_name,student_name,class_name,score from t_studten,t_class,t_student_score,t_subject where t_subject.subject_id=t_student_score.subject_id and t_studten.student_id=t_student_score.student_id and (subject_name,score) in (select subject_name, max(score) from t_student_score a,t_subject b where a.subject_id=b.subject_id group by subject_name)