sum(hours_worked) over (partition by project order by reported_on rows between unbounded preceding and current row) as hours_worked_rt, sum(hours_worked) over ...

sum(hours_worked) over (partition by project) as total_project_hours, avg(hours_worked) over (partition by project) as avg_project_hours lag(reported_on) over ...