with t1 as (select difficulty,uid,score,duration,timestampdiff(second,start_time,submit_time)/60 as finish_time from examination_info ei
join exam_record er on ei.exam_id = er.exam_id
where year(submit_time) = 2021
)

select uid,'activity1' as activity from t1
group by uid
having min(score) >= 85

union

select distinct uid, 'activity2' as activity from t1
where finish_time <= duration/2 and score > 80 and difficulty = 'hard'

order by uid,activity