title: using MAX and COUNT together in mysql query
body: <p>I'm new in mysql. I have 2 mysql tables, <strong>company</strong> and <strong>info</strong>. The 1st table has <em>cid, name, classification, address, city, phone, province</em> and the 2nd table has <em>cid, information dan infodate</em>. They are relational where company.cid=info.cid. I have used </p>
  
  <pre><code>SELECT *, MAX(infodate)
  FROM company
  JOIN info ON company.cid = info.cid
  WHERE classification = 'Hotel'
  GROUP BY name
  ORDER BY MAX(infodate) DESC
  LIMIT 0,7
  </code></pre>
  
  <p>I want to add <strong>COUNT</strong> in that statement so each company will have sum of informations to display. Thank you.</p>