with temp as ( select exam_id, uid, timestampdiff(second, start_time, submit_time) / 60 as spend_time, # (submit_time - start_time) / 60 as spend_time, score, tag, difficulty, duration from exam_record join examination_info using (exam_id) where year(start_time) = 2021 ) select distinct uid, "a...