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

分别满足两个活动的人

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


with table1 as (
    select uid, score , 
    timestampdiff(minute, start_time , submit_time ) as timediff , difficulty,duration
    from exam_record left join examination_info using(exam_id)
    where year(submit_time) = 2021
),
# activity1
table2 as (
    select uid , min(score) , 'activity1' as activity
    from table1
    group by uid ,activity
    having min(score) >= 85
),
# activity2
table3 as (
    select uid,max(score), 'activity2' as activity 
    from table1
    where difficulty = 'hard' and timediff < 0.5 * duration  # 难度为hard 且 一半时间
    group by uid, activity
    having max(score) >= 80
)
select uid,activity
from table2

union all 
 
select uid,activity
from table3
subquery
order by uid, activity

全部评论

相关推荐

04-30 21:35
已编辑
长安大学 C++
晓沐咕咕咕:评论区没被女朋友好好对待过的计小将可真多。觉得可惜可以理解,毕竟一线大厂sp。但是骂楼主糊涂的大可不必,说什么会被社会毒打更是丢人。女朋友体制内生活有保障,读研女朋友还供着,都准备订婚了人家两情相悦,二线本地以后两口子日子美滋滋,哪轮到你一个一线城市房子都买不起的996清高计小将在这说人家傻😅
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

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