数据准备
drop table scores;
create table scores
(
id int ,
lesson varchar(12),
score int);
insert into scores(id,lesson,score) values(1,'match',90);
insert into scores(id,lesson,score) values(2,'match',85);
insert into scores(id,lesson,score) values(3,'match',85);
insert into scores(id,lesson,score) values(4,'match',95);
insert into scores(id,lesson,score) values(5,'english',66);
insert into scores(id,lesson,score) values(6,'english',88);
insert into scores(id,lesson,score) values(7,'physics',78);
insert into scores(i