execute block as
declare variable poss varchar(1000);
declare variable vall numeric (16,0);

begin
for execute statement
'select row_number() over (order by sum(pricetowdisc) desc) || '' место - '' || badgename || '' [Б+'' || caname||'']'' as poss, sum(pricetowdisc) as total from opers o
join contragents c on caid=opcaidown
join emps e on e.empid=o.empid
where opdate between dateadd(day,-30,current_timestamp) and current_timestamp and optype in (100,101,102,150,151,152)
group by caname,badgename
order by total desc'
WITH AUTONOMOUS TRANSACTION
ON EXTERNAL 'd:\basa\DBSERVER.FDB'
into :poss, :vall
do
begin
end

execute block as
  declare variable poss varchar(1000);
  declare variable vall numeric (16,0);
begin
  for
    execute statement
Q'{
select
  row_number() over (order by sum(pricetowdisc) desc) || ' место - ' || badgename || ' [Б+' || caname|| ']' as poss,
  sum(pricetowdisc) as total
from
  opers o
  join contragents c on caid=opcaidown
  join emps e on e.empid=o.empid
where opdate between dateadd(day, -30,current_timestamp)
  and current_timestamp and optype in (100,101,102,150,151,152)
group by caname, badgename
order by total desc
}'
    WITH AUTONOMOUS TRANSACTION
    ON EXTERNAL 'd:\basa\DBSERVER.FDB'
    into :poss, :vall
  do
  begin
  end
end