title: COUNT records returned by group by
body: <p>How to select count the records returned by group by?</p>
  
  <p>I have 13 records in 1 table that when I group by 1 field, would return 1 record.</p>
  
  <p>But when I use <code>select count(*)</code> it still returns 13 instead of 1.</p>
  
  <p>How can I achieve the result I want?</p>