题解 | #分别满足两个活动的人#

分别满足两个活动的人

https://www.nowcoder.com/practice/a126cea91d7045e399b8ecdcadfb326f

#activity1要求每次考试分数都要85以上,若最低的为85,则后面每次都会比他高
select uid,"activity1" as activity
from exam_record
where year(submit_time)="2021"
group by uid
having min(score)>=85

union all

select distinct uid,"activity2" as activity
from examination_info as ei
join exam_record as er
on ei.exam_id=er.exam_id
where year(er.submit_time)="2021"
and ei.difficulty="hard"
and timestampdiff(minute,start_time,submit_time)*2<ei.duration
and er.score>80

order by uid

全部评论

相关推荐

刷牛客的我很豁达:你是不是对算法有什么误解,你没手握两篇顶刊顶会,还想搞算法岗,有顶刊顶会在算法岗算才入门
点赞 评论 收藏
分享
10-10 01:10
已编辑
深圳大学 测试开发
面了100年面试不知...:六月到九月,四个项目一个实习,是魔丸吗
投了多少份简历才上岸
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务