title: Order by two columns that changes sort order
body: <p>I have a table that looks likes this</p>
  
  <pre><code>ID  Side    Name    
  --  ---    -------
  1   Left   Bravo
  1   Right  Alpha
  2   Left   Delta
  2   Right  Charlie
  3   Left   Fox
  3   Right  Echo
  </code></pre>
  
  <p>I need the Table to looks like this where it sorts the ID column and the Side column but the Side column is sorted Right and then Left</p>
  
  <pre><code>ID  Side    Name    
  --  ---    -------
   1   Right   Alpha
   1   Left    Bravo
   2   Right   Charlie
   2   Left    Delta
   3   Right   Echo
   3   Left    Fox
  </code></pre>
  
  <p>I have tried using <code>order by ID,Side DESC</code> &amp; <code>ASC</code> but the query result does not change</p>