sorry. sql statements for creating table and records are in attached file because they seemed too long to me. the sample data in post actually is not data. I used to explain what kind of sorting I need. I think by this way it would be more clear. but if you say so, sure I can remove these explanations, but this time how would I explain reader what kind of sorting do I need.

please direct me to right way my friend, thanks.