Thank you both very much for your help. Thanks also for the link on how to post to the site. You have to watch out for us noobs...

Thank you! That got me going in the right direction. Here is what I ended up with that works.

SELECT i.Course, i.Grade, CONVERT(decimal(5, 2), COUNT(i.Grade)) / CONVERT(decimal(5, 2),...