+ 2

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);

18th May 2021, 4:19 PM
Lizette Figueredo
7 Answers
+ 6
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;
5th Aug 2022, 4:04 AM
Balakumar Santhosh
+ 1
create table leaderboard (place int,nickname varchar (1000),rating int); insert into leaderboard (Place,nickname, rating) values (1,'Predator',9500),(2, 'JohnWar',9300),(3,'NightWarrior',8900); select * from leaderboard
18th Jun 2022, 12:31 PM
Rajesh Kumar
Rajesh Kumar - avatar
0
create table leaderboard (nickname varchar (1000),best int); insert into leaderboard (nickname,best) values ('amy88',876),('james42',568),('snoop',155); select * from leaderboard
3rd Feb 2024, 7:21 AM
Pankaj
Pankaj - avatar
0
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;
29th Jul 2024, 6:22 PM
mohammad zare
- 2
Hey I sorted with this SELECT * FROM leaderboard;
19th May 2021, 11:17 AM
Lizette Figueredo
- 2
You forgot to use SELECT * From leaderboard; lol.
26th May 2021, 2:32 AM
Devan Hall
Devan Hall - avatar