+ 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);
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;
+ 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
0
create table leaderboard
(nickname varchar (1000),best int);
insert into leaderboard
(nickname,best)
values ('amy88',876),('james42',568),('snoop',155);
select * from leaderboard
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;
- 2
Hey I sorted with this
SELECT *
FROM leaderboard;
- 2
You forgot to use SELECT * From leaderboard; lol.