Re: How to write an SQL for this?

Not to mention the two kids I caught cheating on a take-home final! They both used the same wildly incorrect code (there were some other details, but I won't mention them here so as not give give tips to avoid getting caught). The ironic part of the story is that even if they had both aced the final (would never happen, but...), one would have gotten an F anyway, and the other a D. So now, in addition to their Fs, there is a cheating note in their academic record.

Students: The profs are better at detecting cheating than you are at covering it up. Don't cheat- it's not worth it. You don't learn anything, and you'll never get a job, as you won't be able to pass the job interview. If you do manage to fool someone, it won't last.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077233676.23611_at_yasure...
> S. D wrote:
>
> > Thanks in advance.
> >
> > Two tables - professors and courses. Additional table for term (has
> > year, semester fields)
> >
> > Need an SQL statement for the following. No complicated statements
> > required but a simple one will do.
> >
> > "multiple professors teach same course. No one prof can teach it all
> > by himself."
> >
> > Any help is appreciated. Thanks again!
>
> We don't do people's homework for them ... we only provide hints.
>
> My hint to you ... put some effort into it and then post your best
> attempts. We will try to get you on-track where you missed the mark.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Feb 25 2004 - 13:26:04 CST