按所提供范围内的每个日期的历史日期分组

Am stuck with this for days. wanna group a sql result set by historical dates. so want a result to be grouped by date from each date in the date specified range all the way back in time. Here is my sql so far, but it groups the result by date instead of historical date. Am stuck with this for days. wanna group a sql