with einfo as ( select emp_id,exam_id, timestampdiff(second,start_time,submit_time)*1.0/3600 etime, score, avg(timestampdiff(second,start_time,submit_time)*1.0/3600) over(partition by exam_id) avg_etime, avg(score) over(partition by exam_id) avg_score from exam_record ) select ei.emp_id,em.emp_level...