select 1 seq, user_name, application_name,'1.STARTED Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'STARTED' group by user_name, application_name, status union select 2 seq, user_name, application_name,'2.STARTED Days Remaining' PROPERTY, sum(nvl(daysremaining,duration)) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'STARTED' group by user_name, application_name,status union select 3 seq, user_name, application_name, '3.PENDING Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' AND user_name is not null and status = 'PENDING' group by user_name, application_name, status union select 4 seq, user_name, application_name, '4.PENDING Days Remaining' PROPERTY, sum(nvl(daysremaining,duration)) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'PENDING' group by user_name, application_name, status union select 5 seq, user_name, application_name,'5.NOT STARTED Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'NOT STARTED' group by user_name, application_name,status