You might want to try something like this:

select number of classes, student, count(*) as Count
From tablename
group by number of classes, student

Good luck!