Incorrect population order[Guided Project: Analyzing CIA Factbook Data Using SQL]

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.