title: Join 2 tables and Count the number of occurrence specific field in SQL
body: <p>I have 2 tables , "T_COMMON_COUNTRY" and "T_HEI_STUDENTDATA." using left join I joined these tables</p>
  
  <p>this is my query </p>
  
  <pre><code>SELECT 
      [T_COMMON_COUNTRY].[COUNTRY_ID], 
      [T_COMMON_COUNTRY].[COUNTRY], 
      [T_HEI_STUDENTDATA].[STUDENT_ID]
  
  FROM ([T_COMMON_COUNTRY]
  
   LEFT JOIN [T_HEI_STUDENTDATA]
  
   ON [T_COMMON_COUNTRY].[COUNTRY] = [T_HEI_STUDENTDATA].[STDCOUNTRY])
  </code></pre>
  
  <p>now I' getting view like this </p>
  
  <pre><code> |   Country ID   |     County      | Student ID |
   |       1        |      USA        |     12     |
   |       1        |      USA        |     5      |
   |       2        |      UK         |     11     |
   |       2        |      UK         |     2      |
  </code></pre>
  
  <p>I want Count the number of students (Student_IDs) relate to a country ,</p>
  
  <p>I want get a view exactly like below </p>
  
  <pre><code> |   Country ID   |     County      | Students |
   |       1        |      USA        |     2    |
   |       2        |      UK         |     2    |
  </code></pre>