SQLize | PHPize | SQLtest

with -- пакеты p as ( select 3 as cnt from dual union all select 2 as cnt from dual union all select 5 as cnt from dual union all select 2 as cnt from dual union all select 1 as cnt from dual ), -- бутылки b as ( select level as num from dual where 0 > 0 connect by level <= 11 ) -- пакеты с поместившимися бутылками select 'Вместимость '||c2.pack_cnt as pack, listagg(c2.bottle_num,', ') within group (order by c2.bottle_num) as bottles from ( -- бутылки на местах в пакетах select c1.*, -- сопоставляем место в пакете номеру бутылки по порядку (select bb.bottle_num from (select row_number() over (order by b.num) as bottle_num from b) bb where bb.bottle_num = c1.pack_place) bottle_num from ( -- места в пакетах select p.pack_num, p.pack_cnt, row_number() over (order by p.pack_num,d.n) as pack_place from (select row_number() over (order by p.cnt desc) as pack_num, p.cnt as pack_cnt from p) p, (select level as n from dual connect by level <= (select max(p.cnt) from p)) d where d.n <= p.pack_cnt order by p.pack_num,d.n )c1 )c2 group by c2.pack_num,c2.pack_cnt order by c2.pack_num;