Nobody's going to help you now that you started spamming the forums.

That smells homework and you could at least have posted DDL and DML code and what you have so far and not try to make people make your homework for you.