SOLOLEARN Team Please help SQL (Video Game Scores) | Sololearn: Learn to code for FREE!

+1

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

5/18/2021 4:19:27 PM

Lizette Figueredo

5 Answers

New Answer

0

You forgot to use SELECT * From leaderboard; lol.

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;

0

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