编辑代码

CREATE DATABASE test;

USE test;
CREATE TABLE student (
    student_id INT,
    name varchar(20),
    major varchar(20),
    score INT
);

INSERT INTO student VALUES(1, '小白','英语', 62);
INSERT INTO student VALUES(2, '小黑','语文', 70);
INSERT INTO student VALUES(3, '小蓝','生物', 50);
INSERT INTO student VALUES(4, '小黄','生物', 80);
INSERT INTO student VALUES(5, '小紫','生物', 50);
INSERT INTO student VALUES(6, '小云','生物', 70);

SELECT * FROM student ORDER BY score DESC LIMIT 3 WHERE major = '生物';