Need Help with sql code

Hi Trisha_Ravindra 

We cannot run a query on the text in your question. What we need is a table with some data. So let's divide the work between us, You will provide what you can and we will fill the blank 🙂 

please post:

1) Queries to CREATE your table(s) including indexes
2) Queries to INSERT sample data.
3) The desired result given the sample, as text or image of excel for example.
4) A short description of the business rules, and how you got 1-2 of the results
5) Which version of SQL Server you are using (this will help to fit the query to your version).

Note: This is something you should always provide when you have questions related to queries.

Regards,