It will be better if you provide DDL and sample data in a ready to use format so that volunteers here can copy+paste it in their machine and start working with less effort

The sample data you have provided is not clear enough

Please check the link in my signature if you want to know how to do this

I am sure you have people helping in no time if you follow the article