-- Все продажи по менеджерам
-- 1. Без хранения агрегатов
select m.MANAGER_NAME, s.qty, s.amount from (
select MANAGER_ID, SUM(SALE_QTY) qty, SUM(SALE_AMOUNT) amount
from FACT_SALE group by MANAGER_ID
) s inner join DIM_MANAGER m on (s.MANAGER_ID = m.MANAGER_ID)
order by s.amount desc where ROWNUM < 10

-- 2. С хранением агрегатов
insert into FACT_SALES(MANAGER_ID, SALE_QTY, SALE_AMOUNT)
select MANAGER_ID, SUM(SALE_QTY), SUM(SALE_AMOUNT) 
from FACT_SALES group by MANAGER_ID

select MANAGER_ID, SALE_QTY, SALE_AMOUNT
from FACT_SALE
where PRODUCT_ID IS NULL and OFFICE_ID IS NULL and CITY_ID IS NULL
and MONTH_ID IS NULL
order by s.amount desc where ROWNUM < 10