有大佬知道sql怎么写的吗，我只过了30%，我的思路大概是(字段具体名忘了)select name,max(score),classname from student,score where student.sid=score.sid group by classname