title: mySQL ORDER based on multiple criteria
body: <p>My actual table is much more in-depth than this but let's assume I have a table that looks like this...</p>
  
  <pre><code>Record_ID     Due_Date     Style
  =========     ==========   =====
  100           2018-01-01   10
  101           2018-01-02   20
  102           2018-01-03   12
  103           2018-01-04   10
  104           2018-01-05   20
  105           2018-01-06   12
  106           2018-01-02   10
  </code></pre>
  
  <p>What I want is a query that will determine the first due date and then return that record along with all other records with the same style regardless of the due date. It should then be followed by the next due date of another style and keep going. A successful output would be in this order...</p>
  
  <pre><code>Record_ID     Due_Date     Style
  =========     ==========   =====
  100           2018-01-01   10
  106           2018-01-02   10
  103           2018-01-04   10
  101           2018-01-02   20
  104           2018-01-05   20
  102           2018-01-03   12
  105           2018-01-06   12
  </code></pre>
  
  <p>If you look at just the first record for each <code>Style</code> the output is in order.
  See records 100,101,102</p>
  
  <p>If you look at all the records for a given <code>Style</code> the output is sorted by date.
  See records 100,106,103</p>
  
  <p>If you look at just the <code>Style</code> column the output is has all the like <code>Style</code> together but not necessarily in numerical order.</p>
  
  <p>By doing having this output, it is easy to see what <code>Style</code> is due first but all records in that same <code>Style</code> will be completed prior to moving on to the next <code>Style</code></p>