title: Using IN expression in Order By clause
body: <p>How do I properly use the IN expression in Order By clause? I have a few questions like this and I cannot find a solution.</p>
  
  <p>I want to select ID, lastname, country from the customer list and order it by the north american countries first (canada and usa, with corresponding ID) then once those have populated, I want to order the remaining data based on ID alone.</p>
  
  <pre><code>Select customerid, lastname, country
  From customer
  Where country IN ('Canada', 'USA')
  Order By CustomerID
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/PBhq2.gif" rel="nofollow">Here</a> is what they are looking for.</p>
  
  <p>I have tried Where clause and nesting the query but I am new to this.</p>
  
  <p>Any advice is welcome.</p>