I'm afraid that what you are asking for is not clear enough for me to offer a solution.
Please see the link in my signature for details of how to post DDL and sample data in such a way as to make this clear. If you take the time to do this, a working & tested solution will be usually be provided within a matter of minutes.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.