title: sorting by value specific - ORDER BY
body: <p>I am trying to sort a query using ORDER BY where I need to sort 3 columns one by one. And the third column is value specific.</p>
  
  <p>Eg: If i have 3 columns a,b and c
  I need to use ORDER BY a, b desc, c='3' asc, c</p>
  
  <p>What I want to do is first sort order is a, then b in desc order then I want the values of which has 3 to be sorted and then the remaining values which are not 3.</p>