In my query, I need to look at the last 12 week ending dates, or 12 months in the where clause. Could anyone help me out adding this clause?
select week_ending as 'Week Ending',
avg(roll_change_time)) as 'Average Roll Change Time'
group by week_ending
Thank you much.