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