Practice 6.2 Sorting Results

Question

Leaderboarding

Six players have competed in a chess tournament and their scores have been tallied.
Here is the table of Players:

Sort the players by losses to derive the leaderboard.

My code is as below:

SELECT * FROM Players
ORDER BY losses, firstname, lastname;

However, it says “no input”

Please help.

Answer 1

SELECT * FROM Players
ORDER BY losses;

Answer 2

Thanks Simba!

Answer 3

This is the correct Answer :

SELECT * FROM Players
ORDER BY losses ASC
LIMIT 3

Answer 4

This is my answer:

SELECT * FROM Players
ORDER BY losses ASC
LIMIT 6