With 
Tabhandle_temp as (

Select log_create_date, log_action, row_number() over(order by log_create_date) as row# from srm_sbl_parse where (log_thread = 'siebel thread 8') and (log_action = 'siebelClientService - handle')
),

Select log_create_date, log_action, row_number() over(order by log_create_date) as row# from srm_sbl_parse where (log_thread = 'siebel thread 8') and (log_action = 'siebelClientService % - successful')
),

Tabtimes_temp as (
Select tabhandle_temp.log_create_date as handle_time, tabsuccess_temp.log_create_date as success_time
From tabhandle_temp
Full join tabsuccess_temp
On tabsuccess_temp.row# = tabhandle_temp.row#
)

Select to_char(handle_time, 'dd month yyyy') as "day", count(success_time) as "success", avg(extract(second from(success_time - handle_time))) as "average time"
From tabtimes_temp
where(success_time > handle_time) and success_time in (select min(log_create_date)
From tabsuccess_temp
Where log_create_date > handle_time)
Group by to_char(handle_time, 'dd month yyyy')