ТЕМА:

SELECT st.name AS магазин,
       trunc(sals.date_when_sold, 'year'),trunc(sals.date_when_sold, 'month') AS месяц, SUM(sals.kolvo * gds.price) AS выручка
FROM stores st
JOIN departmentsstores dps ON (dps.id_store = st.id_store)
JOIN goodsinstores gds ON (gds.id_department = dps.id_department)
JOIN goods g ON (g.id_good = gds.id_good)
JOIN sales sals ON (sals.id_good = g.id_good)
GROUP BY st.name, trunc(sals.date_when_sold, 'year'), rollup(trunc(sals.date_when_sold, 'month'))
ORDER BY to_char(sals.date_when_sold, 'MM-YY'), st.name;

SELECT st.name AS магазин,
       trunc(sals.date_when_sold, 'year'),trunc(sals.date_when_sold, 'month') AS месяц, SUM(sals.kolvo * gds.price) AS выручка
FROM stores st
JOIN departmentsstores dps ON (dps.id_store = st.id_store)
JOIN goodsinstores gds ON (gds.id_department = dps.id_department)
JOIN goods g ON (g.id_good = gds.id_good)
JOIN sales sals ON (sals.id_good = g.id_good)
GROUP BY st.name, trunc(sals.date_when_sold, 'year'), rollup(trunc(sals.date_when_sold, 'month'))
ORDER BY trunc(sals.date_when_sold, 'month'), st.name;