欧美1区2区3区激情无套,两个女人互添下身视频在线观看,久久av无码精品人妻系列,久久精品噜噜噜成人,末发育娇小性色xxxx

請從試卷作答記錄表中找到SQL試卷得分不小于該類試卷平均得分的用戶最低得分。 示例數(shù)據(jù) exam_record表（uid用戶ID, exam_id試卷ID, start_time開始作答時(shí)間, submit_time交卷時(shí)間, score得分）： id uid exam_id start_time submit_time score 1 1001 9001 2020-01-02 09:01:01 2020-01-02 09:21:01 80 2 1002 9001 2021-09-05 19:01:01 2021-09-05 19:40:01 89 3 1002 9002 2021-09-02 12:01:01 (NULL) (NULL) 4 1002 9003 2021-09-01 12:01:01 (NULL) (NULL) 5 1002 9001 2021-02-02 19:01:01 2021-02-02 19:30:01 87 6 1002 9002 2021-05-05 18:01:01 2021-05-05 18:59:02 90 7 1003 9002 2021-02-06 12:01:01 (NULL) (NULL) 8 1003 9003 2021-09-07 10:01:01 2021-09-07 10:31:01 86 9 1004 9003 2021-09-06 12:01:01 (NULL) (NULL) examination_info表（exam_id試卷ID, tag試卷類別, difficulty試卷難度, duration考試時(shí)長, release_time發(fā)布時(shí)間） id exam_id tag difficulty duration release_time 1 9001 SQL hard 60 2020-01-01 10:00:00 2 9002 SQL easy 60 2020-02-01 10:00:00 3 9003 算法 medium 80 2020-08-02 10:00:00 示例輸出數(shù)據(jù)： min_score_over_avg 87 解釋：試卷9001和9002為SQL類別，作答這兩份試卷的得分有[80,89,87,90]，平均分為86.5，不小于平均分的最小分?jǐn)?shù)為87
示例1

輸入

drop table if exists examination_info;
CREATE TABLE  examination_info (
    id int PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID',
    exam_id int UNIQUE NOT NULL COMMENT '試卷ID',
    tag varchar(32) COMMENT '類別標(biāo)簽',
    difficulty varchar(8) COMMENT '難度',
    duration int NOT NULL COMMENT '時(shí)長',
    release_time datetime COMMENT '發(fā)布時(shí)間'
)CHARACTER SET utf8 COLLATE utf8_general_ci;

drop table if exists exam_record;
CREATE TABLE  exam_record (
    id int PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID',
    uid int NOT NULL COMMENT '用戶ID',
    exam_id int NOT NULL COMMENT '試卷ID',
    start_time datetime NOT NULL COMMENT '開始時(shí)間',
    submit_time datetime COMMENT '提交時(shí)間',
    score tinyint COMMENT '得分'
)CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO examination_info(exam_id,tag,difficulty,duration,release_time) VALUES
  (9001, 'SQL', 'hard', 60, '2020-01-01 10:00:00'),
  (9002, 'SQL', 'easy', 60, '2020-02-01 10:00:00'),
  (9003, '算法', 'medium', 80, '2020-08-02 10:00:00');

INSERT INTO exam_record(uid,exam_id,start_time,submit_time,score) VALUES
(1001, 9001, '2020-01-02 09:01:01', '2020-01-02 09:21:01', 80),
(1002, 9001, '2021-09-05 19:01:01', '2021-09-05 19:40:01', 89),
(1002, 9002, '2021-09-02 12:01:01', null, null),
(1002, 9003, '2021-09-01 12:01:01', null, null),
(1002, 9001, '2021-02-02 19:01:01', '2021-02-02 19:30:01', 87),
(1002, 9002, '2021-05-05 18:01:01', '2021-05-05 18:59:02', 90),
(1003, 9002, '2021-02-06 12:01:01', null, null),
(1003, 9003, '2021-09-07 10:01:01', '2021-09-07 10:31:01', 86),
(1004, 9003, '2021-09-06 12:01:01', null, null);

輸出

87

備注:
保證至少有一個(gè)有效的SQL類別的試卷作答分?jǐn)?shù)
加載中...