Where is the error? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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