title: counting no of exams a student has appeared in exam combining two tables
body: <p>I have two below tables student and examination:
  Student table:</p>
  <pre><code>Id   Name
  1    Samantha
  2    Jane
  3    Bob
  4    Scarlet
  5    David
  </code></pre>
  <p>Examination:</p>
  <pre><code>student_id   subject
  1     Biology
  1     physics
  3     history
  4     geography
  4     geography
  </code></pre>
  <p>Now I need to find which student has appeared in which examination how many number of times, the exact ans I expect is:</p>
  <pre><code>student.id examination.subject no_of_times
  1          biology      1
  1          physics      1
  3          history      1
  4          geography    2
  
  </code></pre>
  <p>I have tried below query, but got wrong ans:</p>
  <pre><code>select Student.id, examination.subject, count(*) from Student join examination Student.id = examination.student_id;
  
  </code></pre>
  <p>Please help me to write the correct query to get correct expected output!!</p>
  <p>Thank You!</p>