select max(score),name,subject from user_score as s group by name; select score,name,subject from user_score as s group by name order by score desc limit 2;