title: COUNT is more than what I have
body: <p>I have a SQL statement </p>
  
  <pre><code>SELECT COUNT(appl.applicantID) 
  FROM course_Batch pD 
  INNER JOIN applicant appl ON pD.programmeID = appl.programmeID
  GROUP BY pD.programmeID
  </code></pre>
  
  <p>So, in my <code>applicant</code> table, I've 2 applicants tied to a <code>record</code> in my <code>course_Batch</code>. </p>
  
  <p>However, when I use that SQL statement I pasted above, I get 4. Because in my <code>course_Batch</code> table, I've multiple records under 1 <code>programme ID</code>.</p>
  
  <p><code>ProgrammeDetail</code> table with sample data:</p>
  
  <pre><code>-------------------------------------------
  |  programmeID  |   programmeRequirement  |
  -------------------------------------------
  |     P01       |          20             |
  |     P01       |          20             |
  -------------------------------------------
  </code></pre>
  
  <p><code>Applicant</code> table with sample data:</p>
  
  <pre><code>-----------------------------------
  |   applicantID  |   programmeID  |
  -----------------------------------
  |    A001        |      P01       |
  |    A002        |      P01       |
  -----------------------------------
  </code></pre>
  
  <p>Is there a way to achieve this?</p>
  
  <pre><code>---------------------------------------------------------------
  |  programmeID  |   programmeRequirement  |   applicantCount  |
  ---------------------------------------------------------------
  |   P01         |          20             |         2         |
  ---------------------------------------------------------------
  </code></pre>