select min(start_date) start_date, max(end_date) finish_date, round(coalesce(decode(sum(decode(daysremaining, 0, duration)), null, 0, sum(decode(daysremaining, 0, duration))) / sum(decode(daysremaining, 0, duration, coalesce(daysremaining, duration))) * 100, 0), 2) percent_completed, task, module, workflow, project, project_id, workflow_order, workflow_id, count(task_id) total_tasks, sum(case when daysremaining = 0 and task is not null then 1 else 0 end) tasks_completed, trunc(max(end_date)) - trunc(min(start_date)) duration from t_project_plan_tasks_v --where project_id = 8522 group by task, module, workflow, project, project_id, workflow_order, workflow_id