SQLplus

I'm trying to count the number of 'classes' each student is taking, but I'm supposed to report back 0 if there are none. Right now, it just doesn't respond with the student.
Anyone out there been through a database class who solved this?

Just as a little aside, I hope I'm not derailing the thread here, but how do you guys pronounce SQL?
1) Sequel
2) Squill
3) Sickle/Suckle
4) Ess-queue-elle