ДОБРЫЙ ДЕНЬ!


ЕСТЬ 2 ЗАПРОСА. кАК МНЕ ВЫЧЕСТЬ РЕЗУЛЬТАТ ОДНОГО ЗАПРОСА ОТ РЕЗУЛЬТАТА ДРУГОГО ЗАПРОСА:



1 ЗАПРОС:
select s.operator,avg(s.billsec) from
(select s.operator,s.billsec, @rownum11:=@rownum11+1 as row_number, @total_rows:=@rownum11
from cc_sessions s, (select @rownum11=0) r
where s.billsec > 20
and s.op_answer_time between '2020-03-17 00:00:00' and '2020-03-18 23:59:59'
and s.operator='5655'
order by billsec asc) s
where s.row_number in (floor((@total_rows+1)/2),floor((@total_rows+2)/2))

2 ЗАПРОС:
select t.operator, sum(t.billsec)/2 from
(
SELECT k.row_number,k.operator,k.op_answer_time, k.billsec from
(
SELECT COUNT(billsec)*0.25 as quart from (select @rownum18:=@rownum18+1 as row_number, operator,op_answer_time, billsec
from cc_sessions
where operator='5655'
AND
op_answer_time between '2020-03-17 00:00:00' and '2020-03-18 23:59:59'
AND
billsec >20
order by billsec) r)r,
(select @rownum19:=@rownum19+1 as row_number, operator,op_answer_time, billsec
from cc_sessions
where operator='5655'
AND
op_answer_time between '2020-03-17 00:00:00' and '2020-03-18 23:59:59'
AND
billsec >20
order by billsec) k
where k.row_number in (floor(r.quart),ceil(r.quart))
)t
group by t.operator