题解 | #分别满足两个活动的人#
分别满足两个活动的人
https://www.nowcoder.com/practice/a126cea91d7045e399b8ecdcadfb326f
select uid,'activity1'as activity from examination_info join exam_record using (exam_id) group by uid having min(score)>=85 union all select uid,'activity2'as activity from examination_info join exam_record using(exam_id) where timestampdiff(minute,start_time,submit_time)<0.5*duration and score>80 and difficulty ='hard' order by uid
查看24道真题和解析
