title: How can I count number of students in a class using Mysql?
body: <p>I have two tables:</p>
  
  <hr>
  
  <pre><code>Student table
  
  studentID         fullname        gender         DOB            classID
  91110010003          A             M          03/03/1993       25CCHT02
  91110010004          B             M          08/03/1993       25CCHT02
  91110010005          C             M          04/14/1991       25CCHT02
  93510010005          D             M          07/27/1993       25CCDH02
  93510010008          E             F          03/10/1993       25CCDH02
  93510010009          F             M          06/09/1990       25CCDH02
  93510010010          G             M          18/12/1989       25CCDH02
  99510170307          H             M          05/06/1991       25CCDH02
  99510180112          L             M          07/12/1992       25CCDH02
  99510180150          M             M          22/03/1993       25CCDH02
  </code></pre>
  
  <hr>
  
  <pre><code>LOP 
  class ID                 class name 
  25CCDH02                 3D design
  25CCHT02                    QTM 
  25CCLM01                    LT
  </code></pre>
  
  <hr>
  
  <p>I want to create a statement which show the result like :</p>
  
  <pre><code>class ID                 class name              student_count 
  25CCDH02                 3D design                     7
  25CCHT02                    QTM                        3
  25CCLM01                    LT                         0
  </code></pre>