select t.emp_id , t.emp_level , t.exam_tag from(select em.emp_id , em.emp_level , ei.tag exam_tag , er.score , timestampdiff(minute , start_time , submit_time) answer_time , avg(timestampdiff(minute , start_time , submit_time)) over(partition by ei.exam_id)avg_time , avg(er.score) over(partition by ...