CREATE TABLE Students (
StudentID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(50),
Score INT
);
INSERT INTO Students (Name, Score) VALUES ('Alice', 90);
INSERT INTO Students (Name, Score) VALUES ('Bob', 85);
INSERT INTO Students (Name, Score) VALUES ('Charlie', 80);
INSERT INTO Students (Name, Score) VALUES ('David', 75);
INSERT INTO Students (Name, Score) VALUES ('Eva', 70);
INSERT INTO Students (Name, Score) VALUES ('Frank', 65);
INSERT INTO Students (Name, Score) VALUES ('Grace', 60);
INSERT INTO Students (Name, Score) VALUES ('Henry', 55);
INSERT INTO Students (Name, Score) VALUES ('Ivy', 50);
INSERT INTO Students (Name, Score) VALUES ('Jack', 45);
SELECT *
FROM Students
WHERE Score = (
SELECT DISTINCT Score
FROM Students
ORDER BY Score DESC
LIMIT 1 OFFSET 2
);
