请使用sql写出每门课成绩前两名的学生姓名及分数

请使用sql写出每门课成绩前两名的学生姓名及分数

有三张表，学生表：学号，姓名；课程表：课程号，课程名称；成绩表：学号，课程号，分数；请使用sql写出每门课成绩前两名的学生姓名及分数.

insert into student values
("202202","李四"),
("202203","王五"),
("202204","王二麻子"),
("202205","张敏"),
("202206","张慧"),
("202207","张飞"),
("202208","杨立果"),
("202209","杨三")

insert into curriculum values
("11111","数学"),
("22222","英语"),
("33333","语文"),
("44444","化学"),
("55555","物理"),
("66666","生物"),
("77777","地理")

insert into curriculum values
("202201","11111","66"),
("202201","22222","65"),
("202201","33333","70"),
("202201","44444","77"),
("202201","55555","80"),
("202202","11111","65"),
("202202","22222","70"),
("202202","33333","92"),
("202202","44444","72"),
("202202","55555","67"),
("202203","11111","77"),
("202203","22222","80"),
("202203","33333","75"),
("202203","44444","88"),
("202203","55555","89"),
("202204","11111","80"),
("202204","22222","80"),
("202204","33333","67"),
("202204","44444","90"),
("202204","55555","78"),
("202205","11111","98"),
("202205","22222","89"),
("202205","33333","80"),
("202205","44444","60"),
("202205","55555","79"),
("202206","11111","89"),
("202206","22222","99"),
("202206","33333","87"),
("202206","44444","88"),
("202206","55555","100"),
("202207","11111","80"),
("202207","22222","92"),
("202207","33333","79"),
("202207","44444","93"),
("202207","55555","95"),
("202208","11111","99"),
("202208","22222","87"),
("202208","33333","86"),
("202208","44444","58"),
("202208","55555","98"),
("202209","11111","100"),
("202209","22222","100"),
("202209","33333","90"),
("202209","44444","81"),
("202209","55555","98")