title: How to write a query with count
body: <p>I have two tables as follows:</p>
  
  <pre><code>==================
  StudentsClasses  
  ----------------
  ID (Registration ID of the class)
  StudentID (ID of student taking class)
  ClassID (ID of certain class)
  ----------------
  ==================
  
  Students
  ---------------
  ID (ID of student)
  Name (Name of student)
  GradeLevelID (Grade of student)
  ---------------
  ==================
  </code></pre>
  
  <p>And they are joined by StudentsClasses.StudentID and Students.ID.</p>
  
  <p>I am trying to write a query to return the students with the least classes registered. My query is:</p>
  
  <pre><code>SELECT Students.Name, COUNT(StudentsClasses.StudentID) AS Expr1
  FROM     StudentsClasses INNER JOIN
                    Students ON StudentsClasses.StudentID = Students.ID
  GROUP BY StudentsClasses.StudentID, Students.Name
  ORDER BY Expr1
  </code></pre>
  
  <p>However, that only returns all the students with at least 1 class in ASC order.</p>
  
  <p>I know the correct answer is 7 students with 0 classes.</p>
  
  <p>How can I modify my query to return only those 7 students with 0 classes.</p>