1  with dogovor(film_id,client_id,vidacha,vozvrat) as (
  2      select 1,1,date '2017-03-20',date '2018-01-30' from dual union all
  3      select 1,2,date '2017-03-25',date '2018-03-22' from dual union all
  4      select 1,3,date '2018-03-20',date '2018-04-02' from dual union all
  5      select 1,4,date '2018-01-20',date '2018-02-02' from dual union all
  6      select 2,1,date '2010-03-20',date '2018-04-01' from dual
  7      )
  8     ,film (film_id,filmn) as (
  9      select 1,'Операция Ы' from dual union all
 10      select 2,'Avatar' from dual )
 11  select substr(max(to_char(count(*),'fm00000000')||'#'||f.film_id||'. '||f.filmn),10) x
 12  from
 13    dogovor d inner join film f on f.film_id = d.film_id
 14  where
 15   to_char(d.vidacha, 'MM') = '03'
 16* group by f.film_id, f.filmn
SQL> /

X
-----------------------------------------------------
1. Операция Ы