Entry tags:

SQL Really Satisfies

I am so awesome. Not really. But I figured out how to do this all by myself:

select i.lastname,i.firstname,count(ic.instructorid) as 'Number of Courses' from instructor as i,instructorcourse as ic where i.type='Facilitator' and i.instructorid = ic.instructorid group by i.lastname,i.firstname

This is primarily for my future reference.

(11 comments)

Post a comment in response:

From:

Anonymous This account has disabled anonymous posting.

OpenID

Dreamwidth account

If you don't have an account you can create one now.

Subject

HTML doesn't work in the subject.

Formatting type

Message