WITH 
WAREHOUSE AS
   (
      SELECT  1  id,  1  cart_id,  1  dept_id FROM dual UNION ALL
      SELECT  2  id,  1  cart_id,  1  dept_id FROM dual UNION ALL
      SELECT  3  id,  2  cart_id,  2  dept_id FROM dual UNION ALL
      SELECT  4  id,  2  cart_id,  2  dept_id FROM dual UNION ALL
      SELECT  5  id,  3  cart_id,  3  dept_id FROM dual
   ), 

DEPARTMENT as
  (
    select  1  id, 'OTK' nname from dual union all
    select  2  id, 'ROOM 4' nname from dual union all
    select  3  id, 'ROOM 6' nname from dual
  ),

PRINTER as
  (
    select  1  id, 'HP' nname from dual union all
    select  2  id, 'CANON' nname from dual
  ),

CARTRIGE as
  (
    select  1  id, 'cart1' nname,  1  printer_id, 'Y' active, trunc(sysdate) DDATE from dual union all
    select  2  id, 'cart2' nname,  2  printer_id, 'Y' active, trunc(sysdate) DDATE from dual union all
    select  3  id, 'cart3' nname,  2  printer_id, 'Y' active, trunc(sysdate) DDATE from dual union all
    select  4  id, 'cart4' nname,  3  printer_id, 'Y' active, trunc(sysdate) DDATE from dual
  )

select 
  (select DEPARTMENT.nname from DEPARTMENT where DEPARTMENT.id = WAREHOUSE.dept_id) dep,
  PRINTER.nname,
  CARTRIGE.DDATE,
  count( 1 ) as koll_vo
from WAREHOUSE, CARTRIGE, PRINTER
where WAREHOUSE.cart_id = CARTRIGE.id
  and PRINTER.id = CARTRIGE.printer_id
  and CARTRIGE.DDATE BETWEEN to_date('01.01.2010','dd.mm.yyyy') and to_date('31.01.2010','dd.mm.yyyy')
group by WAREHOUSE.dept_id, CARTRIGE.DDATE, PRINTER.nname