David,

that was not much help.

You cannot build any right query unless you know what you are querying for.

I still see the same logical error (according to my understanding) in the approach, but I cannot tell for sure if it's an error in fact.

Can you tell IN PLAIN ENGLISH WHAT ARE YOU LOOKING FOR?

What does it really mean: the day and 2 earlier days?

Which days to be taken as "earlier days"?