+ 1

Where is the error?

There are 6 players in the players' table, sort the player by their losses and limit to 3 players. Select * from players Order by losses Limit 3;

1st May 2021, 9:36 PM
Zool Jam Baq
Zool Jam Baq - avatar
4 Answers
+ 2
do you need to sort in descending (highest to lowest) order? if you do, you will need to add ā€œdescā€ after ā€œorder by lossesā€. that line will look like ā€œorder by losses descā€.
2nd May 2021, 1:04 AM
you are smart. you are brave.
you are smart. you are brave. - avatar
+ 1
Show as your attempt and then it will be easy for solving https://www.sololearn.com/discuss/333866/?ref=app
2nd May 2021, 12:18 AM
Matias
Matias - avatar
+ 1
Post your code here
2nd May 2021, 3:24 AM
Atul [Inactive]
+ 1
SELECT * FROM players ORDER BY losses Limit 3;
2nd May 2021, 4:07 AM
Zool Jam Baq
Zool Jam Baq - avatar