title: Mysql to return greatest to least results
body: <p>Not a sql guru but I have this query that counts the number of customers per dealership. </p>
  
  <pre><code>SELECT d_id, COUNT(DISTINCT c_number)
  from distinct_customers
  group by d_id
  limit 5;
  </code></pre>
  
  <p>However, it is only returning the top results.  </p>
  
  <p>I am trying to create a query that returns the results from greatest to least limit to the to 5. </p>