SELECT I.start, I.end,
(select count(*) from message_candidates M WHERE M.date >= I.start AND M.date <= I.end
AND M.sender='chris.germany@enron.com')
as cnt
FROM intervals_1wk_1wk I
GROUP BY I.start, I.end;