title: Is it possible to order by two fields in a given table,one in ascending and the other in descending order at the same time?
body: <p>Recently, I have come across a question that has been asked in an interview which states that:</p>
  
  <blockquote>
    <p>You have mysql database with a table students. Write a query string to
    select all the items of the table students and order by two fields one
    ascending and the other descending.</p>
  </blockquote>
  
  <p>Let's have a table "students" for example:</p>
  
  <p><a href="https://i.stack.imgur.com/Z8X7F.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z8X7F.jpg" alt="enter image description here"></a></p>
  
  <p>From this example, if we order by <strong><em>Score</em></strong> in descending order then there is no way to order by <strong><em>roll_no</em></strong> in ascending order at the same time.</p>
  
  <p>From the point of view of the question, can there be written any query to obtain the desired result Or is the question ambiguous or wrong or my approach to the understanding of the question is wrong? </p>