Outer join and subquery

[kebrith]

Hi,

The thing that improve it a bit better is to changing the between clause
to > date 1 and < date 2.