DECLARE
  <variables>
BEGIN
  WHILE <whatever criteria constitutes more processing to be done> LOOP
    <your query and processing>
  END LOOP;
END;
/

with c1 as (
            select  c.*,
                    row_number() over(order by customer_score desc) customer_rank
              from  customer c
           ),
     a1 as (
            select  a.*,
                    row_number() over(order by agent_score desc) agent_rank,
                    count(*) over() agent_count
              from  agent a
           )
select  customer_name,
        customer_num,
        customer_score,
        agent_name,
        agent_number,
        agent_score,
        customer_score + agent_score total_score
  from  c1,
        a1
  where trunc((customer_rank - 1)/agent_count) * agent_count + agent_rank = customer_rank
  order by customer_rank,
           agent_rank
/ 

CUSTOMER_NAME CUSTOMER_NUM CUSTOMER_SCORE AGENT_NAME AGENT_NUMBER AGENT_SCORE TOTAL_SCORE
------------- ------------ -------------- ---------- ------------ ----------- -----------
Oria                    15            100 Kelly                 2          65         165
Jake                    11             60 Jackson               3          45         105
James                   13             55 Kelly                 2          65         120
John                    12             35 Jackson               3          45          80
Jill                    16             35 Kelly                 2          65         100
harvard                 14             25 Jackson               3          45          70

6 rows selected.

SQL>