There is a bug in my SQL program,video score game .I can't able to squash it

Answer 1

SoloProg ,

it is not seen as a helpful behavior when we are going to post a code, as long as the op has not shown his attempt here.

it is helpful to give hints and tips, so that the op has a chance to find a solution by himself.

Answer 2

CREATE TABLE leaderboard (
place INT,
nickname VARCHAR,
rating INT);

INSERT INTO leaderboard (place, nickname, rating)
VALUES
(1, 'Predator', 9500),
(2, 'JohnWar', 9300),
(3, 'NightWarrior', 8900);

SELECT * FROM leaderboard;