select

Insert

insert into fact_sale_modem_test  
select /*+ parallel (ab, 8)*/ 
trunc(sa.conn_date, 'mm') conn_month, trunc(t.rep_month, 'mm') rep_month, 
count(distinct(sa.clnt_id)) value, 'count_client' def,  'm21'  modem_type
from
   dwh.fact_clients sa,
   dwh.fact_clients_hist ab,
   fbi_time t
where
  sa.conn_date >= '01.01.2016'
  and sa.conn_date <= '30.11.2016'
  and ab.rep_date = trunc(t.rep_month,'mm') -1
  and trunc(sa.conn_date, 'mm') <> trunc(t.rep_month, 'mm')
  and t.rep_month = '30.11.2016'
  and ab.status = 2
  and ab.clnt_id = sa.clnt_id
group by trunc(sa.conn_date, 'mm'),trunc(t.rep_month, 'mm')