+ 1

Practice 6.2 Sorting Results

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.

16th May 2021, 3:26 AM
Chin Eu
Chin Eu - avatar
4 Respuestas
+ 10
SELECT * FROM Players ORDER BY losses;
16th May 2021, 4:19 AM
Simba
Simba - avatar
+ 1
Thanks Simba!
16th May 2021, 7:44 AM
Chin Eu
Chin Eu - avatar
+ 1
This is the correct Answer : SELECT * FROM Players ORDER BY losses ASC LIMIT 3
24th Jan 2023, 10:02 AM
Neha Dipak Shinde
Neha Dipak Shinde - avatar
0
This is my answer: SELECT * FROM Players ORDER BY losses ASC LIMIT 6
27th Feb 2023, 8:11 PM
Jens-Andreas Hoheisel
Jens-Andreas Hoheisel - avatar