Content as shown in figure ~ crab crab crab crab crab crab

CodePudding user response:

Bosses don't think this is too simple

CodePudding user response:

Bosses hope you can hard-working,,,

CodePudding user response:

refer to the second floor lhdz_bj response:

bosses hope you can hard-working,,,

knowledge reserves is insufficient, do not to come out

CodePudding user response:

The third topic
The 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.s ubject_id=b.s ubject_id group by subject_name)