题解 | #插入记录（二）#

insert into exam_record_before_2021(uid,exam_id,start_time,submit_time,score)
select uid,exam_id,start_time,submit_time,score from exam_record where year(start_time) < 2021
and submit_time is not null;

SELECT * FROM exam_record_before_2021;