select sum( case when Total_Time <= :T Then 1 Else 0 End ) / Count(1) * 100 Perc_Acheived From ( SELECT application_no, SUM (work_time) total_time FROM FN_WFLOG_MV WHERE (application_no, applicant_no) IN (SELECT application_no, applicant_no FROM FN_WFLOG_MV WHERE WF_TASK_NAME = 'Task1' AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q AND USERID IS NOT NULL AND TO_WF_TASK_NAME = 'To_Task1' AND ACTION_NAME = 'Action1') AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q AND DEPT_NAME = 'DEPT1' AND WF_TASK_NAME = 'TASK1' GROUP BY application_no