题解 | #分别满足两个活动的人#
分别满足两个活动的人
https://www.nowcoder.com/practice/a126cea91d7045e399b8ecdcadfb326f
select uid,'activity1' from exam_record group by uid having min(score) >= 85 union select uid ,'activity2' from examination_info ei inner join exam_record er on ei.exam_id = er.exam_id and difficulty = 'hard' and score > 80 and timestampdiff(minute,start_time,submit_time) < duration / 2 order by uid;
思特威电子科技成长空间 78人发布