why I am getting incorrect population order while using descending.
Hello @LokeshKumar, welcome to the community!
Please avoid posting screenshots of your code. Prefer to paste and format the code in markdown and also post a link to the screen as per these guidelines . When you do this, you make it easier for people to run your code to reproduce your results and help you.
I am moving this to the Q&A Section.
Because you’re ordering in the subquery.