SQL query for a specific scenario

Hello @Yogita_Gaikwad

It would be better to explain your requirement with some sample data?

Thanks