Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

13 May 2023

Posted on:

09 May 2023


Exercise 1 question

Hello! In exercise 1 you are asked to order result by the first row_number column and by salary in ascending order. In most cases all is fine, but for some managers you receive switches in salary order. Output on the screen is from the solution file. I got the same trouble so I wanted to check how it was fixed in solutions)

1 answers ( 0 marked as helpful)
Posted on:

13 May 2023



in this case row_num1 is prevailing factor of sorting, so the numbers are: 57, 58, 59 etc,

WHILE in row_num2 - i.e. salary rank is 15, 13, 14.  The salary order would be right, if there were not the 1 sorting condition = row_num1.

I hope this helps,



Submit an answer