select class_id, name, max(score) score from tablename where score>=85 and score<=90 group by class_id;