As you, I tried with simple code and it worked, I modified it little bit:

select Student, course, credit, sum(gradeno) as Grades

, case

...