title: MySQL count query for one to many relationship
body: <p>I have two tables: "member" and "question". Each member can ask more than one question.</p>
  
  <p>I want to retrieve the count of members who have been asked more than 3 questions</p>
  
  <p>My query so far:</p>
  
  <pre><code>SELECT DISTINCT  q.question_id, COUNT( q.question_id ) AS question_id_count
  FROM member m
  
  inner join question q on m.member_id = q.member_id
  
  GROUP BY m.member_id
  HAVING (
  COUNT( q.question_id ) &gt;3
  )
  </code></pre>
  
  <p>What can I do to improve this query? Thank you</p>