title: Run a query so that all values in any category that contains "Important" come first
body: <p>I have a table with a whole bunch of rows. For simplicity, we'll say that each row belongs to categories A, B, C, or D. Those rows also have values of Important, Not important, or Boring. I want to sort such that if a category contains any value that is important, all values in that category come first, with the important rows first. It would look something like:</p>
  
  <p>A - <strong>Important</strong></p>
  
  <p>A - <strong>Important</strong></p>
  
  <p>A - Not Important</p>
  
  <p>C - <strong>Important</strong></p>
  
  <p>C - Boring</p>
  
  <p>B - Boring</p>
  
  <p>B - Boring</p>
  
  <p>D - Not important</p>
  
  <p>D - Boring</p>