i got the idea out of it but i am bit confused because in our case its Date difference not the between, i cant give hardcoded date there to use...

i was also confused i thought ninja added wrong code..anyways...

for table structure as you can see the data is coming from multiple tables.... execution plan of above query i can...