title: SQL Server order by different values
body: <p>I have a table where <code>status</code> can be either <code>GOLD</code>, <code>SILVER</code>, <code>ACTIVE</code> or <code>INACTIVE</code>.</p>
  
  <p>I would like to sort by that... in that order and take top X. How can I write that in my query?</p>
  
  <p>Currently I am filling up a list by first querying for <code>GOLD</code> and then checking the size of the list, then querying for <code>SILVER</code> and again checking the size etc. </p>