select 10, 20, 90 from dual

union all

select 20, 30, 68 from dual

union all

select 30, 40, 314 from dual

union all

select 40, 40, 191 from dual;

select 10 + mod(level, 10), level/10 from dual connect by level <= 50000

union all

select 20 + mod(level, 10), level/10 from dual connect by level <= 50000

union all

select 30 + mod(level, 10), level/10 from dual connect by level <= 50000

union all

select 40 + mod(level, 10), level/10 from dual connect by level <= 50000;

frequency/sum(frequency) over () as proportion,

floor(10000 * frequency/sum(frequency) over ()) as limit

from table_1;

select range_start, range_end, floor(10000 * frequency/sum(frequency) over ())

from table_1

),

cte2 (grp, value, limit, rn) as (

select t2.grp, t2.value, cte1.limit,

row_number() over (partition by cte1.range_start order by t2.value) as rn

from cte1

join table_2 t2

on (cte1.range_end > cte1.range_start and t2.grp >= cte1.range_start and t2.grp < cte1.range_end)

or (cte1.range_end = cte1.range_start and t2.grp = cte1.range_start)

)

select grp, value

from cte2

where rn <= limit;