title: SQL - Order by amount of occurrences
body: <p>It's my first question here so I hope I can explain it well enough,
  I want to order my data by amount of occurrences in the table.
  My table is like this:</p>
  
  <pre><code>id      Daynr
  1       2
  1       4
  2       4
  2       5
  2       6
  3       1
  4       2
  4       5
  </code></pre>
  
  <p>And I want it to sort it like this:</p>
  
  <pre><code>id      Daynr
  3       1
  1       2
  1       4
  4       2
  4       5
  2       4
  2       5
  2       6
  </code></pre>
  
  <p>Player #3 has one day in the table, and Player #1 has 2.
  My table is named "dayid"
  Both id and Daynr are foreign keys, together making it a primary key</p>
  
  <p>I hope this explains my problem enough, Please ask for more information it's my first time here.</p>
  
  <p>Thanks in advance</p>