title: Order by COUNT per value
body: <p>I have a table which stores IDs and the city where the store is located.</p>
  
  <p>I want to list all the stores starting with the stores that are in the city where there are the most stores.</p>
  
  <p>TABLE</p>
  
  <pre><code>ID CITY
  1  NYC
  2  BOS
  3  BOS
  4  NYC
  5  NYC
  </code></pre>
  
  <p>The output I want is the following since I have the most stores in NYC, I want all the NYC location to be listed first.</p>
  
  <pre><code>1  NYC
  4  NYC
  5  NYC
  2  BOS
  3  BOS
  </code></pre>