You are right..Jan Van der Eecken, Its my mistake.
What I really wanted is the query written by Wolfgang.
The duration I have written there is wrong, its only an indicator anyway.
Thank You Wolfgang for that query and Jan Van der Eecken for correcting me:-P