题解 | 完成员工考核试卷突出的非领导员工

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

先找出不是领导的人，然后按照两个考试科目分别筛选即可