SQL coding issue, please help.?

More homework, eh? Give it a shot yourself...if you get stuck, post what you have and maybe I'll take a look...and make sure to mention which DBMS it is...that can have a difference as to syntax.