只需要把select * from ()的括号里面写另一个select语句就行。
select sum(paly_duration)/count(paly_duration) form
(
select play_duration from
(
select sum(play_duration) from play_log
where dt = 某天
group by user_id
)
order by play_duration
)
where ROWNUM>100
