Thank you for your reply, please find the sample data in the attached file

Thanks you all for your replies. Below is the scenario & DDL (work in progress..)

To answer Jacob Wilkins questions,

I'm posting my table scripts & and ...

I got the weekly count, Thank you.

but how to get the week start date & week end date for a month ?