You must first study your SQL book and try coding a solution, then maybe someone will help you out in debugging your homework.