title: MySQL count amount of values and then return top 3 of them
body: <p>Below is a table from which I want to make a query from:</p>
  <pre><code>+-------+-----------+
  | id    |color_value|     
  +-------+-----------+
  | 3     | yellow    |    
  | 5     | yellow    |   
  | 12    | red       |   
  | 33    | green     |    
  | 47    | purple    |   
  | 58    | red       |  
  | 59    | red       |    
  | 61    | orange    |   
  | 62    | green     |  
  </code></pre>
  <p>So what I want to achieve is to first count the total of color values for each color and then return top 3 used colors.</p>