set term ^;

execute block returns (DD Date, S float) as
declare variable doc_date_in date;

begin
  for select t.date_doc from table t
  where t.sent_date between dateadd(day, -1, CURRENT_DATE) and CURRENT_DATE
  group by 1
  into :doc_date_in do
    for select
      t.date_doc,
      sum(t.sum_doc)
    from table t
    where t.date_doc=:doc_date_in
    group by 1
    into :DD, :S do
    suspend;
end^

set term ;^