title: Need to Add the Count in Select
body: <p>The following query allows me to count the Type of class a student takes.</p>
  
  <pre><code>SELECT student_schedule.Grade, LEFT(student_schedule.Course,2) AS 'Type',  
  COUNT(*) AS 'Count'
  FROM student_schedule
  GROUP BY Type, Grade
  ORDER BY Grade, Type
  </code></pre>
  
  <p>The result is:</p>
  
  <p><a href="https://i.stack.imgur.com/5qO51.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5qO51.png" alt="enter image description here"></a></p>
  
  <p>I would now like to find the ratio for each Type by Grade. The fourth column after Count would be  (303+529+50 or 882) for all rows of Grade 7 and (719+139+15 or 873) for Grade 8. I need a SUM in my SELECT statement I think. To clarify, the fourth column would be 882 for Grade 7 and 873 for Grade 8 in every row for that grade. Any help would be appreciated.</p>