This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
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)
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,