We're not here to do your work for you, although obviously we're happy to help out if there's anything in particular you don't understand. Therefore please will you show us what you've tried so far? Also, you're more likely to get help if you post table DDL and sample data in the form of INSERT statements.

John