题解 | 完成员工考核试卷突出的非领导员工
完成员工考核试卷突出的非领导员工
https://www.nowcoder.com/practice/422dcd6ae72c49c9bbec1aff90d69806
with s1 as(
select emp_id,emp_name,emp_level,register_time from emp_info
where emp_level < 7
)
select s1.emp_id,emp_level,tag exam_tag
from exam_record e join s1 on e.emp_id = s1.emp_id
join examination_info ei on e.exam_id = ei.exam_id
where tag = '企业文化'
and timestampdiff(second,start_time,submit_time)/60 < 27.3
and score > 78.667
or tag = '技术水平'
and timestampdiff(second,start_time,submit_time)/60 < 34.2
and score > 75.833
先找出不是领导的人,然后按照两个考试科目分别筛选即可
