SOLOLEARN Team Please help SQL (Video Game Scores)
This is my solution to the SQL Video Game Scores but there is no output.
Do you know why? Please help!
CREATE TABLE leaderboard (
place INT NOT null,
nickname VARCHAR (30) NOT null,
rating INT NOT null,
PRIMARY KEY (nickname)
);
INSERT INTO leaderboard
(place,nickname,rating)
VALUES
(1,'Predator',9500),
(2,'JohnWar',9300),
(3,'NightWarrior',8900);
CREATE TABLE leaderboard (
place int NOT NULL,
nickname varchar (100) NOT NULL,
rating int NOT NULL,
PRIMARY key (nickname)
);
INSERT INTO leaderboard
VALUES (1, 'Predator', 9500);
INSERT INTO leaderboard
VALUES (2, 'JohnWar', 9300);
INSERT INTO leaderboard
VALUES (3, 'NightWarrior', 8900);
SELECT * from leaderboard;
CREATE TABLE leaderboard (
place int NOT NULL,
nickname varchar (100) NOT NULL,
rating int NOT NULL,
PRIMARY key (nickname)
);
INSERT INTO leaderboard
VALUES (1, 'Predator', 9500);
INSERT INTO leaderboard
VALUES (2, 'JohnWar', 9300);
INSERT INTO leaderboard
VALUES (3, 'NightWarrior', 8900);
SELECT * from leaderboard;
