title: sql order by most recent dates
body: <p>I have this table in my database:</p>
  
  <pre><code>    INSERT INTO `shop_stats` (`date`, `value`) VALUES
  ('09/2014', 326),
  ('08/2014', 1007),
  ('07/2014', 1108),
  ('06/2014', 1027),
  ('05/2014', 895),
  ('04/2014', 650),
  ('03/2014', 683),
  ('02/2014', 563),
  ('01/2014', 499),
  ('12/2013', 568),
  ('11/2013', 522),
  ('10/2013', 371),
  ('09/2013', 347),
  ('08/2013', 376),
  ('07/2013', 418),
  ('06/2013', 567),
  ('05/2013', 357);
  </code></pre>
  
  <p>i need to find a way to display the last 12 months.</p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT * FROM shop_stats ORDER BY date DESC LIMIT 12
  </code></pre>
  
  <p>But it doesn't work correctly.</p>
  
  <p>Any suggestions ?</p>