dwain.c (11/10/2013)
Any time I see something like "Coding required as Subquery NOT as Join" it tells me for sure this is homework.You'll find that few on this forum are willing to do your homework for you.
However if you make a fair attempt at solving the problem, we're likely to try to help you get it right.
Suggest you post some table DDL and sample test data in a consumable form, along with your first attempt.
+1 to all that. Well said on all fronts.
--Jeff Moden
Change is inevitable... Change for the better is not.