题解 | 完成员工考核试卷突出的非领导员工
完成员工考核试卷突出的非领导员工
https://www.nowcoder.com/practice/422dcd6ae72c49c9bbec1aff90d69806
with a as( select exam_id,avg(timestampdiff(second,start_time,submit_time) ) as avg_time,avg(score) as avg_score from exam_record group by exam_id ) select e.emp_id,emp_level,ei.tag as exam_tag from emp_info e join examination_info ei join exam_record er join a on e.emp_id=er.emp_id and ei.exam_id=er.exam_id and er.exam_id=a.exam_id where emp_level<7 and score>avg_score and timestampdiff(second,start_time,submit_time)<avg_time
