select uid, 'activity1' from exam_record group by uid having min(score)>=85 union all select distinct uid, 'activity2' from exam_record er left join examination_info ei on er.exam_id = ei.exam_id where difficulty = 'hard' and score>80 and timestampdiff(minute,start_time,submit_time)<durati...