title: SQL: having trouble with listing min, max, average, count
body: <p>[1]: <a href="https://i.stack.imgur.com/R5Pzz.png" rel="nofollow noreferrer">https://i.stack.imgur.com/R5Pzz.png</a> I am currently trying to list the min, max, avg, and count for each assignmentID. the code i used to create whats shown in the picture is as follows:</p>
  
  <pre><code>SELECT assignment.assignmentID, assignment.assignmentName, grade.grade
  
  FROM grade 
  
  JOIN assignment ON grade.assignmentID = assignment.assignmentID
  </code></pre>
  
  <p>When I add in the min,max,avg,count to the SELECT function it only returns the results for assignmentID 1. how can i get it to do it for all assignments</p>